Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UNION and WHERE
The UNION clause "connects" two SELECT statments. Any SELECT statment
can have a WHERE clause. So the answer to your question is yes.
Something like:
SELECT col1, col2
FROM table1
WHERE col1 = cond1
UNION
SELECT col1, col2
FROM table2
WHERE col2 = cond2;
HTH,
Brian
Olivier BRUZEAUX wrote:
>
> Hi,
>
> Is it possible to use UNION and WHERE in the same statement !!
> If it is possible do you have an example,
>
> Thank you
>
> Olivier
Received on Thu Jan 13 2000 - 08:19:10 CST
![]() |
![]() |