How to SELECT data using 2 tables and show data only from table 1

[haot2307]

I have a table called student
within it are several fields including:

student_matric

I have another table called participation
within it are several fields including:

program_id

student_matric

status

query that i need is, it will show all data from the student table. it will check the students who participated in a program can no longer participate in the program.

it look like this,
After the add button is clicked .. status became join.. students who have chosen by lecture, can't be choosen again...
this system is used by lecture...

[Rabbit]

Table definitions, relationships, sample data, and sample results would help.