>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.
--sb--