Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql to see all diff between two table

Re: sql to see all diff between two table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 23 Sep 2000 17:35:44 +0200
Message-ID: <969723535.12676.2.pluto.d4ee154e@news.demon.nl>

The statement you quote is simply not proper sql. Try
select * from table1
minus
select * from table2;

followed by
select * from table2
minus
select * from table1;

"xgong" <xgong_at_mediaone.net> wrote in message news:Jc3z5.14663$tn.229863_at_typhoon.ne.mediaone.net...
> I have duplicated table, table1 and table2. Then table2 has been updated
> with some fields.
> How to get the all diff between two tables using sql?
>
> following does not work for me:
>
> select * from table1 where * not in (select * from table2)
>
> thank you for your help!
>
> ydeng
>
>
Received on Sat Sep 23 2000 - 10:35:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US