>>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.
sorry...
Select * from TableA where TableA.KeyID not in (select TableB.KeyID from TableB) into cursor MyCursor
Mark McCasland
Midlothian, TX USA