Select records in table1 where table1.field1 doesn't exist in table2.field1
Posted on 2011-03-24
I've got two tables, table1 and table2. Both tables have identical fields except that table1 has an added date field named date (datetime).
I'd like to find all of the records in table1 where table1.field1 is not in (doesn't exist in) table2.field1.
Not sure if this is helpful but, field1 contains duplicate values in both tables.
I'd like to further filter my results by selecting only records from table1 where date='20110323'.
Thanks for any help you can give.