Is there a way to write SQL to find all the records in TableB that match every field in TableA? There are 200+ fields in both tables (same structures) with about less than 100 records in TableA and 200,000 in TableB. I'm trying to do a nested select using the distinct clause, but I can't seem to get either the syntax or the result right. Psuedo code something like:

select * from TableA where AllFields not in (select AllFields from TableB)into cursor Result

...or can I compare arrays somehow?

Thanks!

Regards, Renoir