Check to table of equality

[petermaier]

Hello,

I have two tables and want to find out all records which differ.

The tables have the same columns and primary keys. The server has to look for each entry in table 1 if there is the same entry in table 2 with the same primary key.

How to do?

thanks,
peterm

[davey23uk]

minus command

select col1 from tab1 minus col2 from tab2