>>>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).
>
>SQL Server. Thanks for the suggestion.
;with cte as (select Col1, Col2 from A where SomeExpr)
select * from cte
UNION
select Col1, Col2 from table2 where Col1 in (select Col1 from cte)
If it's not broken, fix it until it is.
My Blog