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 Link to comment https://forums.phpfreaks.com/topic/266186-sql-statement-help/ 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) Link to comment https://forums.phpfreaks.com/topic/266186-sql-statement-help/#findComment-1364065 Share on other sites More sharing options...
stijn0713 Posted July 24, 2012 Author Share Posted July 24, 2012 gracias! Link to comment https://forums.phpfreaks.com/topic/266186-sql-statement-help/#findComment-1364070 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.