Himar,
You can have two WHERE clauses.

>

>select (fieldlist) from Table1;
>  union select (fieldlist) from Table2 where (condition)
>

>
>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?
>
>Hilmar.