[QUOTE][SIZE=1]Originally posted by AnsMe
Hi, I want to write a query for following scenario:
I have two tables A and B. Each has two columns ID, SUPPLIER.
I want to find out all the ID + SUPPLIER that exists in A and does not exist in B.
I have Oracle database and am using SQL editor.
select id,supplier from a where
( id,supplier) not in
(select id,supplier from b)