By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,545 Members | 1,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,545 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:


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




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

Expert Mod 10K+
P: 12,401
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.