Re: Simple SQL Question

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 13 Feb 2001 22:27:36 -0800
Message-ID: <3A8A2558.E28DA8F0_at_exesolutions.com>


> Is there a simple way to query a table whose records are formatted as
> follows:
>
> FIELD1 VARCHAR(12) - Ex. Data: NORTH
> FIELD2 VARCHAR(12) - Ex. Data: 1000
> FIELD3 VARCHAR(12) - Ex. Data: 2000
> FIELD4 VARCHAR(12) - Ex. Data: 3000
>
> with a result set that contains multiple records in the following format:
>
> NORTH 1000
> NORTH 2000
> NORTH 3000
>
> without doing a UNION? We're trying to avoid changing the table structure
> and the overhead of runniing UNION statements.

Not that I am aware of.

But by all means change the data structure. You can either do it now or do it later but you will need to do it or you will be fighting this bad design forever.

Daniel A. Morgan Received on Wed Feb 14 2001 - 07:27:36 CET

Original text of this message