[thelist] Quick SQL help

[Rob Smith]

Hi,

Take a sample order (Order, SKU, Warehouse, Location):
1234 ____ ABC ____ A ____ 2
1234 ____ ADE ____ C ____ 40
1235 ____ EEF ____ C ____ 55
1236 ____ EEJ ____ A ____ 1
1236 ____ JJK ____ A ____ 1

How do I narrow this list down to show all orders that had at least one
"A" location in it?

Thanks,


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)