Re: Query Help

From: Ioan Hirsch <yohan_at_malam-zafon.co.il>
Date: 7 Apr 2002 11:18:54 -0700
Message-ID: <b392e52b.0204071018.57dfa023_at_posting.google.com>


Try this :

(select 1,item2 from table1

 minus
 select 1,item3 from table2)
union
(select 2,item3 from table2

 minus
 select 2,item2 from table1)

The results with code=1 will be for items exclusive to table1 and the results with code=1 will be for items exclusive to table2. Received on Sun Apr 07 2002 - 20:18:54 CEST

Original text of this message