Union Query and Where Clause

[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.

 

[Ken Snell \(MVP\)]

Not within the UNION query itself. You'd need to save the UNION query and
then write a different query that uses that UNION query as the data source,
and then put the WHERE clause in that new query:

SELECT * FROM UNIONQuery
WHERE FieldName = "value";