>> 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.
Thanks for the assistance and clarification. Appreciate your time!
Pál
> David J.
--
--
Pál Teleki