Sql command for query

		Wrox Programmer Forums > Database > SQL Language
Sql command for query

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

December 12th, 2005, 10:10 AM

prashar

Registered User

Join Date: Sep 2005

Posts: 7

Thanks: 0

Thanked 0 Times in 0 Posts

Sql command for query

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#)

ques) write a command to get supplier numbers for suppliers who supply the same part to all projects

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning Command Button to Query	young20	Access VBA	1	November 6th, 2006 12:15 PM
About SQL command	hoailing22	ASP.NET 1.0 and 1.1 Basics	8	May 19th, 2005 07:31 PM
executing sql command	redface	Crystal Reports	0	April 6th, 2005 05:14 PM
SQL "where" command question	module0000	VB Databases Basics	7	October 5th, 2004 12:46 PM
Sql Command	hanzahalka	ADO.NET	0	July 8th, 2003 09:59 AM