A
alexander199
Is it is possible to apply WHERE clause to the entire result of the
UNION query?
Something like this:
(Select f1 from A
UNION
Select f1 from B)
where f1 = '1';
I tried to parenthesize the individual selects but it does not work.
So I had to put the where clause in each individual select to filter
the result.
Thanks.
UNION query?
Something like this:
(Select f1 from A
UNION
Select f1 from B)
where f1 = '1';
I tried to parenthesize the individual selects but it does not work.
So I had to put the where clause in each individual select to filter
the result.
Thanks.