James,

> Yes Helen. I just copy-pasted the SQL off the email and onto isql and
> "Hey Presto - It still works!". So, can we therefore safely go with
> Sean's opinion that the ambiguity logic was made more "intelligent"?
>
> Exactly how intelligent?

You can have both aliased and non-aliased column references as long as
the column is only found in one of the tables referred to in the
statement.

Previously, once you used a table alias, the engine required that all
columns to be aliased. Such that your example statement would have had
to be written like this to be valid:

select
E.FULL_NAME,
E.PHONE_EXT,
E.HIRE_DATE,
E.SALARY
...
from
EMPLOYEE_PROJECT EP
JOIN EMPLOYEE E ON E.EMP_NO=EP.EMP_NO...


Sean