[thelist] Quick SQL Help

Rob Smith rob.smith at lexjet.com
Fri Jul 21 10:37:20 CDT 2006


I need to isolate the following orders at which the whole thing came
from the same warehouse (Per line item). Then the next thing is the
opposite...all orders that didn't come from the correct warehouse. For

Order#	Ship	Preferred
30000		TX	OH
30000		OH	OH
30001		WI	WI
30002		CO	CO
30002		DE	DE
30003		NY	TX
30003		TX	TX

The first report should return order numbers: 30001 and 30002. The
second report should return order numbers 30000 and 30003.

Any help on this brain tease would be appreciated,

Rob Smith
rob.smith at lexjet.com
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

More information about the thelist mailing list