Re: Bug with ANSI/92 joins USING clause in Oracle 10g? Can't SELECT on join fields?

dananrg_at_yahoo.com wrote:
> The following query, using the ON clause, works fine:
>
> -- Query #1
> select e.employee_id, d.department_id, d.department_name
> from employees e INNER JOIN departments d
> ON e.department_id = d.department_id
>
> The same query, employing (pun intended) the USING clause does not
> work:
>
> -- Query #2
> select e.employee_id, d.department_id, d.department_name
> from employees e INNER JOIN departments d
> USING (department_id)
>
> ORA-25154: column part of USING clause cannot have qualifier
>

That is not a bug; bugs do not have error codes assigned to them. Not liking ANSI joins, and not at a 10G installation, guessing: using (d.department_id)?

-- 

Regards,
Frank van Bortel