>>>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


GOT IT! Thanks. Now comes the fun part. Figuring out mismatches based on additions and subtractions of some fields.

Thanks again.