stijn0713 Posted July 24, 2012 Share Posted July 24, 2012 I have three tables: respondents | examinations | respondents_examinations How can i based on the id of the respondents avoid that the potential respondents i search for in a select from query are not already added to the respondents_examination? e.g. in my record results i don't want to show the respondents that are already added to the respondents_examinations Quote Link to comment Share on other sites More sharing options...
xyph Posted July 24, 2012 Share Posted July 24, 2012 SELECT whatever FROM respondents WHERE id NOT IN (SELECT respondents_id FROM respondents_examinations) Quote Link to comment Share on other sites More sharing options...
stijn0713 Posted July 24, 2012 Author Share Posted July 24, 2012 gracias! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.