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