On Monday, July 18, 2016, Pál Teleki <ellenallhatatlan(at)gmail(dot)com> wrote:
> Now, why can't I use deptot and stot_per_man aliases in my query? It would
> greatly simplify the SQL by removing the need for a subquery (or inline
> view
> as Oracle calls them).
>
SQL execution of a query is only done once. Referring to an alias at the
same level in a query would require some kind of duplication to work.
Either two phase processing or cloning the subselect that is being alised
and executing it a second time to be used in the second location. Neither
are desirable.
David J.