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

I surrender!

select * from suadps_packup_file;
where suadps_packup_file.niin not in (select nalcomis_packup_file.niin);
into cursor MyCursor

This returns 'Command is missing required clause'

both tables(suadps_packup_file and nalcomis_packup_file) are in the same .dbc and have an index on the field 'niin' as usual I thought I had tried the obvious but I'm confused