0
I have a query to select all the colors not shipped by supplier S1
Query:
select distinct parts.color as part_color
from parts
where parts.partno
in (select parts.partno
from shipments,parts,suppliers
where parts.partno=shipments.partno
and suppliers.supplierno=shipments.supplierno
and sup...