|
Subject:
|
Query to get project numbers
|
|
Posted By:
|
prashar
|
Post Date:
|
12/12/2005 9:11:25 AM
|
(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
|
|
Reply By:
|
jbenson001
|
Reply Date:
|
12/13/2005 1:10:08 AM
|
Test it and find out.
|
|
