biglittle — 2013-03-13T15:31:01-04:00 — #1
I want to select all the rows from Table 1 that don't have their ID in a second table. Such as:
I need to find all the Table1 entries that don't have an ID in Table2 under "Table1ID".
guido2004 — 2013-03-13T15:47:57-04:00 — #2
What you need is a LEFT JOIN
r937 — 2013-03-13T18:05:32-04:00 — #3
or a NOT EXISTS subquery
system — 2014-10-07T23:53:19-04:00 — #4
This topic is now closed. New replies are no longer allowed.