- P(P#, Pname, Color, Weight) aka Parts
- S(S#, Sname, Status, City) aka Suppliers
- SP(S#, P#, Qty)
I need to find all parts that are supplied by ALL suppliers in London.
So far, I have this:
Code:
select P#, Pname from P where P# in (select x.P# from SP x, sp y where x.S# in (select S# from S where City = 'London') and x.p# = y.p#)
Leave a comment: