>I have decided to force myself to learn SQL, therefore, the resultant headache from which I currently suffer. This shouldn't be this hard! I have two tables, one with 82 records and one with 80 records. The output I want is simple. I want the 2 records in table A that are not in table B.
>
>Please don't make me feel too stupid.
Select * from TableA where TableA.KeyID not in (select TableB.KeyID) into cursor MyCursor
KeyId in both tables need to be same data type and length.
Mark McCasland
Midlothian, TX USA