[thelist] Quick SQL Help

[Rob Smith]

Hi,

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
example:

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