skaterdav85 Posted August 2, 2010 Share Posted August 2, 2010 I have 2 tables. I want to select all the ID's from table 1 that dont exist in table 2. How would I go about doing that?SELECT *FROM table 1WHERE ... Link to comment Share on other sites More sharing options...
justsomeguy Posted August 2, 2010 Share Posted August 2, 2010 SELECT *FROM table 1WHERE id NOT IN (SELECT id FROM table2) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.