[thelist] simple SQL help please [solved]

Rob Smith rob.smith at lexjet.com
Thu Feb 2 09:49:00 CST 2006


Sorry, I wasn't thinking clearly.

The correct answer is:

Select * 
FROM A 
WHERE A.Company not in 
	(
		Select B.Company 
		FROM A, B 
		WHERE A.Company = B.Company
	)

Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org)





More information about the thelist mailing list