You need to put the FROM into the Second Select Statement...

>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