Query to extract one record from multiple records

From: <cbursell_at_geusnet.com>
Date: Mon, 10 Oct 2011 14:14:11 -0700 (PDT)
Message-ID: <2e776374-a488-4f0d-b697-a60d903e3e07_at_i9g2000yqe.googlegroups.com>



Suppose I have a table like:
ITEM   DESCRIPTION   LOCATION         BIN
1234    RED LAMP       WAREHOUSE    CL32
1234    RED LAMP       STOREROOM    FLOOR
3456    TABLE               WAREHOUSE    XL23
4231   CHAIR                 STOREROOM    M233

I have a query like:
SELECT ITEM, DESCRIPTION, LOCATION, BIN
FROM <TABLE>

However if there are more than one location for the ITEM I want the WAREHOUSE location

For example I only want to return:

1234    RED LAMP       WAREHOUSE    CL32
3456    TABLE               WAREHOUSE    XL23
4231   CHAIR                 STOREROOM    M233

Any ideas? Received on Mon Oct 10 2011 - 16:14:11 CDT

Original text of this message