On Fri, Feb 04, 2005 at 21:40:29 -0600,
"Rodolfo J. Paiz" <rpaiz(at)simpaticus(dot)com> wrote:
>
> The two "tables" shown above are result sets to which I have a handle.
> It is my understanding that I can treat them as tables (albeit temporary
> ones) until they are released. Is that understanding incorrect?
Elements of a from item list can be selects. You just put the select query
inside parenthesis and use an AS clause to give an alias.
Something like:
SELECT tb.a FROM (SELECT a FROM ta) AS tb;