Hi this question was there in my exam. Please see if my solution to the question was right or wrong. There were 4 tables

S(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.