Write a single SQL statement that lists all suppliers supplying ONLY hammers WITHOUT using the difference operation. (A join or subquery would be appropriate.)

I have seen a few answers on this problem already, however none of them correctly answer it. I need a statement that will find the supplier that only carries hammers, no nails.

I have the data needed for the statement below:

SQL> DESCRIBE iggy .part; Name Null? Type PARTNAME NOT NULL VARCHAR2(32) SQL> SELECT * FROM iggy .part; PARTNAME HAMMER NAIL SQL> DESCRIBE iggy.supplier; Name Null? Type SUPPLIERNAME NOT NULL VARCHAR2(32) SQL> SELECT * FROM iggy.supplier; SUPPLIERNAME ----------------------------- NEW YANKEE WORKSHOP, INC. OLD YANKEE WORKSHOP, INC. TOOL TIME, INC. SQL> DESCRIBE iggy.quote; Name Null? Type -------- SUPPLIERNAME PARTNAME QUOTE NOT NULL VARCHAR2 (32) NOT NULL VARCHAR2 (32) NOT NULL NUMBER (8,2) SQL> SELECT * FROM iggy.quote; SUPPLIERNAME PARTNAME NEW YANKEE WORKSHOP, INC. NEW YANKEE WORKSHOP, INC. OLD YANKEE WORKSHOP, INC. TOOL TIME, INC. TOOL TIME, INC. HAMMER NAIL HAMMER HAMMER NAIL QUOTE ---- 1.89 .19 2.09 1.99