Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prasharchandan
Starting Member
1 Post |
 Posted - 2005-12-18 : 06:29:16
|
| (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 forprojects supplied with at least all parts availablefrom supplier S1My Ans:Select J# from J Left outer join SPJ on J.J# = SPJ.J# Where s# = s1 Is my code right? Quest 2. Get supplier numbers for suppliers who supply the same part to all projects? Please do let me know the ans of this, Please its very urgentRegards,Chandan Prashar |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2005-12-18 : 11:26:28
|
| How urgent? When is your homework due? |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
SQL QUERY URGENT Please