Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Too Many Full Outer Joins??? PL/SQL: ORA-00918: column ambiguously defined

Re: Too Many Full Outer Joins??? PL/SQL: ORA-00918: column ambiguously defined

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 15 Sep 2005 07:10:18 +0200
Message-ID: <ld0ii1phjjisscmcmjqb3ld0atk7009ag0@4ax.com> 





On 14 Sep 2005 17:04:17 -0700, "Joe" <joemitchellsc_at_yahoo.com> wrote:



>

>I have no problems when I change the full outer joins to left joins;

>however I need to use full outer joins to get the correct data back.

>

>Any ideas?





ABSOLUTELY NOTHING to do with outer join!!!!!!
You have identical column names in more than one table, and Oracle
can't make out which column is which, as you don't use the
<alias>.<column_name> syntax to qualify those columns.


--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Sep 15 2005 - 00:10:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US