>>>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 can run a separate query into a cursor and than use its result or use the first query as derived table in the second one.
>
>But this won't work with SQL Server, right? Because how do you send a SQL Select that references a query to a SQL Server?
A derived table will work in VFP and SQL Server. With SQL Server 2005 and later you can use CTE.
--sb--