Subject Re: [IBO] How to access field when there are dupe field names
Author Eyal
--- In, Helen Borrie <helebor@t...> wrote:
> ... That's why SQL provides aliasing - to resolve such
> redundancies.
> ...
> Therefore, you are up the creek if you refuse to use aliases to
> resolve redundancies and simplify what you do with IBO.
> ...
> However, if you insist on avoiding the aliasing...

Here's another reason why I prefer to avoid aliasing: Column aliases
can't be used in calulations, JOIN conditions, ORDER BY and GROUP BY.

Building queries in code becomes is thus further complicated, becuase
in some places (column list) I must use aliases, and in other places I
must *not* use aliases.

If only IBO supported fully qualified column names everything would
have been much simpler.