Records in one table not in second table

[mark1110]

If I have two tables with the same fields and want to find out all the records in the first table that are not in the second table, how would I do that?

Thanks,

Mark

 

[fredericofonseca]

look at "exception join" or at "not exists" on your reference manual or search the net for it.

If still required show us some code based on this, along with any errors you may still have.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[PHV]

A starting point:
SELECT A.*
FROM firstTable A LEFT JOIN secondTable B ON A.PrimaryKey = B.PrimaryKey
WHERE B.PrimaryKey IS NULL

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886