using minus
464733Jan 4 2006 — edited Jan 5 2006I 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.