Re: Diffing two equivalent tables

Try using :

Select * from A
MINUS
Select * from B;

Rodger Talevski wrote:

> Hi all,
>
> I have two indentical tables with unique names. I want to find the
> differences between the tables on a row by row basis.
>
> ie Table A and Table B
>
> select *
> from A, B
> where ....
>
> Resultset
>
> Difference between A, B on row , by row basis.
>
> Cheers
> Rodger
>

Received on Fri Aug 07 1998 - 22:18:59 CDT