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 INTERSECT SELECT part FROM orders_list2;PART ---------- TAILPIPE
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 INTERSECT SELECT part FROM orders_list2;PART ---------- TAILPIPE
FROM orders_list1;PART
----------
SPARKPLUG
FUEL PUMP
FUEL PUMP
TAILPIPE SELECT part
FROM orders_list2;PART
----------
CRANKSHAFT
TAILPIPE
TAILPIPE
SELECT part
FROM orders_list1
INTERSECT
SELECT part
FROM orders_list2;PART
----------
TAILPIPE
FROM orders_list1;PART
----------
SPARKPLUG
FUEL PUMP
FUEL PUMP
TAILPIPE SELECT part
FROM orders_list2;PART
----------
CRANKSHAFT
TAILPIPE
TAILPIPE
SELECT part
FROM orders_list1
INTERSECT
SELECT part
FROM orders_list2;PART
----------
TAILPIPE