Re: Diffing two equivalent tables

You can also do this, please check the syntax:

select * from A
where (column1, column2) in
(select column1,column2, column3 from A minus
select column1,column2, column3 from B );

www.oracleguru.net

Rodger Talevski <Talevski.Rodger_at_cabs.com.au> wrote in article <6q8ebb$lpq$1_at_news.mel.aone.net.au>...
> 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 Wed Aug 05 1998 - 11:54:46 CDT