Looking for a NOT situation (two tables)

  • Thread starter Thread starter Edwin Knoppert
  • Start date Start date
E

Edwin Knoppert

I have two tables.
A main table having records, the 2nd table has only a subset of the
maintable.

So both tables can have records where field ID #100 exists.
I'm looking for a SELECT to get the records from the main-table not found in
table2.
 
Edwin,

Untested:

Select * From Table1 Where ID Not In (Select ID From Table2)

Kerry Moorman
 
Back
Top