How to SELECT data using 2 tables and show data only from table 1
<p>I have a table called student
within it are several fields including:</p>

<p>student_matric</p>

<p>I have another table called participation
within it are several fields including:</p>

<p>program_id</p>

<p>student_matric</p>

<p>status</p>

<p>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.</p>

<p>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...</p>
