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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 28 Jun 2008 15:18:49 +0200
Message-ID: <24303$48663a3a$524b5c40$1489@cache4.tilbu1.nb.home.nl>


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
Received on Sat Jun 28 2008 - 08:18:49 CDT

Original text of this message