Find Existing Records
SELECT * FROM Department WHERE dept_id
NOT IN (SELECT dept_id FROM SchoolEvent)
This will display all the department who are not participating in the school Event.
Subquery to find records that exist in one table and do not exist in another table was last modified: October 1st, 2017 by