By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

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

P: 3
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...
Apr 13 '12 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,347
Table definitions, relationships, sample data, and sample results would help.
Apr 13 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.