>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).
If it's not broken, fix it until it is.
My Blog