(S#, SNAME, STATUS, CITY) PRIMARY KEY (S#)

P(P#, PNAME, COLOR, WEIGHT, CITY)PRIMARY KEY (P#)

J( J#, JNAME) PRIMARY KEY (J#)

SPJ( S#, P#, J#, QTY) PRIMARY KEY (S#,P#,J#)

Question: Write a command to get project numbers for
projects supplied with at least all parts available
from supplier S1

My Ans:

Select J# from J Left outer join SPJ
on J.J# = SPJ.J#
Where s# = s1


Please let me know if im right or no

Test it and find out.