Re: Stupid SQL question

Hi,

select city || '-NE' from blah where city = 'OMAHA' and state = 'NEBRASKA'
UNION
select city || '-IA' from blah where city = 'OMAHA' and state = 'IOWA';

						Erika
 						grondzak_at_fria.utc.sk

Marcy A. McKee wrote:
>
> Hello,
> I have the following query:
> select city || '-NE' from blah where city = 'OMAHA' and state =
> 'NEBRASKA'
> that works the way I want it to. My problem is that I want to include an
> additional statement like
> select city || '-IA' from blah where city = 'OMAHA' and state = 'IOWA'
> so that my end result is OMAHA-NE when the state is equal to Nebraska
> and OMAHA-IA when the state is equal to Iowa. Any ideas on how to do
> this?
>
> Thanks,
> Marcy
Received on Fri May 29 1998 - 02:17:25 CDT