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: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 17 Sep 2005 10:47:48 +0200
Message-ID: <i1mni1lbp05g9ofd202fv89t4qdadrqj6u@4ax.com>


On Thu, 15 Sep 2005 07:10:18 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>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,

Maybe you could refrain from replying until you have enough time again to read the *all* the OP's text with due attention, so we could see some of your usual level of response.

Jaap. Received on Sat Sep 17 2005 - 03:47:48 CDT

Original text of this message

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