Posted on 2008-11-19
I need a SQL statement that selects records where a column value in one table does not exist in another table
TableA has a column called Part. There could be 1 million plus records in this table
TableB has a column called NonPart. This table could have several thousand records.
What I need is a list of all items in TableA where the PART is NOT IN TableB NonPart column.
I've tried several things, nothing seems to work. I end up getting some records that are correct, and some that are not (meaning it does exist in TableB).
Any help is greatly appreciated.