Hello all,
In a WITH query, are table aliases within a CTE isolated from the rest
of the query? For example, if I do this -
  with my_cte as (
    select * from my_table t
  )
  ....
- can I re-use the alias "t" elsewhere in the same query?
I had a dig through the appropriate section of the docs, but the answer
wasn't obvious to me there.
Thanks,
Ray.
-- 
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie