>>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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham