Need help for NOT EXISTS query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Thao
    New Member
    • Apr 2011
    • 2

    Need help for NOT EXISTS query

    Hi,
    With these tables:

    Supplier (SNO, SName, Status, City)
    Part (PNO, PName, Color, Weight, City)
    Shipment (SNO, PNO, Qty)

    How can I find the suppliers who have shipped each and every part type. Only use NOT EXISTS.
    Thanks.
  • gpl
    New Member
    • Jul 2007
    • 152

    #2
    Why do you have the requirement Only use NOT EXISTS.Is this homework?

    Comment

    Working...