Simple SQL Question
From: Jeff Anderson <jeanderso9_at_yahoo.com>
Date: Tue, 13 Feb 2001 23:02:40 GMT
Message-ID: <k2ji6.127179$9v2.1660112_at_quark.idirect.com>
Date: Tue, 13 Feb 2001 23:02:40 GMT
Message-ID: <k2ji6.127179$9v2.1660112_at_quark.idirect.com>
Is there a simple way to query a table whose records are formatted as
follows:
with a result set that contains multiple records in the following format:
NORTH 1000
FIELD1 VARCHAR(12) - Ex. Data: NORTH
FIELD2 VARCHAR(12) - Ex. Data: 1000
FIELD3 VARCHAR(12) - Ex. Data: 2000
FIELD4 VARCHAR(12) - Ex. Data: 3000
NORTH 2000
NORTH 3000
without doing a UNION? We're trying to avoid changing the table structure
Thanks. Received on Wed Feb 14 2001 - 00:02:40 CET