Home » Other » Training & Certification » Error in SQL (Outer Join)
Error in SQL (Outer Join) [message #259548] Wed, 15 August 2007 23:31 Go to next message
Messages: 1
Registered: August 2007
Junior Member
There are four tables, Table1, Table2, Table3, Table4.
Table1 has two columns Table2_code and Table3_code where Table2_code and Table3_code are unique in Table2 and Table3 respectively.
Table4 has foreign key of tables Table2 and Table3. Combination of Table2 and Table3 returns unique row of Table4.
I want to prepare a query that return all rows from Table1, also containing Primary key of Table4 table.
I have created following query :
Table4.Table2_Primary_Key, (primary key of Table2 in Table4 as foreign key)
Table4.Table3_Primary_Key, (primary key of Table3 in Table4 as foreign key)
Table1, Table4, Table2, Table3
Table1.Table2_code = Table2.Table2_code(+)
AND Table2.Table2_Primary_Key = Table4.Table2_Primary_Key(+)
AND Table1.Table3_code = Table3.Table3_code(+)
AND Table3.Table3_Primary_Key = Table4.Table3_Primary_Key(+)
(AND Other required Conditions)

When I executing this query, I am getting an error "ORA-01417: A table may be outer joined to at most one other table".
I got the reason but not able to resolve it because of requirement i.e. all row from Table1.
Please help me.
Re: Error in SQL (Outer Join) [message #259552 is a reply to message #259548] Wed, 15 August 2007 23:46 Go to previous messageGo to next message
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
mbaran ,

I have a requirement to train my pet pig to fly, please give me the steps to meet that requirement.

Please help me.

Thanks much
Re: Error in SQL (Outer Join) [message #259574 is a reply to message #259548] Thu, 16 August 2007 00:35 Go to previous message
Michel Cadot
Messages: 67814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Previous Topic: What is the difference between "local" and "stored" procedures? (renamed by LF)
Next Topic: Help me about Datawarehousing certifications (merged by LF)
Goto Forum:

Current Time: Tue Apr 20 06:01:05 CDT 2021