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: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 15 Sep 2005 08:36:33 +0200
Message-ID: <43291664$0$974$636a55ce@news.free.fr>

"Joe" <joemitchellsc_at_yahoo.com> a écrit dans le message de news: 1126742657.132231.278850_at_g43g2000cwa.googlegroups.com...
|I have about 10 queries that I'm stacking together as follows:
|
| select *
| from (select a, b from q1) q1
| full outer join (select a, b from q2) q2 ON q1.a = q2.a
| full outer join (select a, b from q3) q2 ON q1.a = q3.a
| full outer join (select a, b from q4) q2 ON q1.a = q4.a
| full outer join (select a, b from q5) q2 ON q1.a = q5.a
| full outer join (select a, b from q6) q2 ON q1.a = q6.a;
|
| When I try to compile them into a package, on the 7th query, I get this
| error: PL/SQL: ORA-00918: column ambiguously defined
|
| I've removed the sub-queries one at a time and re-inserted them in
| different orders and they work until the 7th one is added.
|
| 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?
|
| Thanks,
| Joe
|

All your subqueries are named q2!

Regards
Michel Cadot Received on Thu Sep 15 2005 - 01:36:33 CDT

Original text of this message

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