Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql to see all diff between two table
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