Re: UNION and WHERE

From: Phil Preen <obiwan-preen_at_maytheforcebewithyou.co.uk>
Date: Thu, 13 Jan 2000 15:00:04 -0000
Message-ID: <947777641.523530@red.parallax.co.uk>

Olivier BRUZEAUX <obruzeau_at_telecom.capgemini.fr> wrote in message news:85kj9f$26b$1_at_minus.oleane.net...
> Hi,
>
> Is it possible to use UNION and WHERE in the same statement !!
> If it is possible do you have an example,
>

select

something
from

sometable
where

somefield=somevalue
union
select

somethingelse
from

somewhereelse
where

someotherfield=someothervalue
union
select

etc... Received on Thu Jan 13 2000 - 09:00:04 CST