Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

using minus

464733Jan 4 2006 — edited Jan 5 2006
I have 3 similar tables from different sources, how can i list their differences

table1
typeid productname
1234 pencil
1234 pen
1123 paper
1234 clips
2938 rubber

table2
typeid productname
1234 pencil
1234 pen
1123 paper
1234 folder
1234 clips

table3
typeid productname
1234 pencil
2256 glue
9093 clipboard
1234 folder
1234 clips

select t1.typeid, t1.productname, t2.typeid, t2.productname, t3.typeid, t3.productname frm table1 t1, table2 t2, table3 t3
where
t1.typeid = t2.typeid and
t1.typeid = t3.typeid and
t2.typeid = t3.typeid and
t1.productname = t2.productname and
t1.productname = t3.productname and
t2.productname = t3.productname

this query will list all the items with the same typeid and productname, but how can i list all the others ??

thanks.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 2 2006
Added on Jan 4 2006
12 comments
1,881 views