Re: Diffing two equivalent tables

Try this.

select column1,column2, column3 from table A minus
select column1,column2, column3 from table B;

the output will be all the rows in table A which are not present in B.

You can also do the reverse viz

select column1,column2, column3 from table B minus
select column1,column2, column3 from table A;

this will give all rows in table B not contained in table A.

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 Tue Aug 04 1998 - 21:38:38 CDT