Hilmar,

UNION is a way to combine two independent SELECTs. If you want a WHERE clause on the first select just add it there too.

select (fieldlist) from Table1;
   where (condition1) ;
union ;
select (fieldlist) from Table2 ;
   where (condition2)

condition1 and condition2 can be the same thing.

>It seems to me that (condition) applies only to the second part of the "unionized" query. Is there a way to apply a condition to the entire result set?