You can use the MINUS Set operator for doing this.


Consider these two queries and their results:

SELECT part
FROM orders_list1;

PART
----------
SPARKPLUG
FUEL PUMP
FUEL PUMP
TAILPIPE

SELECT part
FROM orders_list2;

PART
----------
CRANKSHAFT
TAILPIPE
TAILPIPE


SELECT part
FROM orders_list1
MINUS
SELECT part
FROM orders_list2;

PART
----------
SPARKPLUG
FUEL PUMP

Hope this Helps
Anurag