>Hi,
>
>Can I use a query created in the first part of a UNION in the second part? For example
>
>

>select Col1, Col2 from Table1 A where (SomeExpr)
>union
>select Col1, Col2 from Table2 where Col1 in (Select Col1 from A)
>

>
>TIA.

No. You need to use derived table. Is it VFP query or SQL Server query?

In SQL Server you can use the favorite of mine - Common Table Expression (cte).