I want to select all the rows from Table 1 that don’t have their ID in a second table. Such as:
Table1
-ID
-Name
Table2-
-ID
-Table1ID
-Stuff
I need to find all the Table1 entries that don’t have an ID in Table2 under “Table1ID”.
I want to select all the rows from Table 1 that don’t have their ID in a second table. Such as:
Table1
-ID
-Name
Table2-
-ID
-Table1ID
-Stuff
I need to find all the Table1 entries that don’t have an ID in Table2 under “Table1ID”.
What you need is a LEFT JOIN
or a NOT EXISTS subquery