Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Too Many Full Outer Joins??? PL/SQL: ORA-00918: column ambiguously defined
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
![]() |
![]() |