Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Double outer join on table

user594312Sep 12 2012 — edited Sep 12 2012
Hi

Let's say I have three tables ORDERS, PRODUCT and CLIENT. I want a query that will give me all PRODUCT and CLIENT combinations and the total sum of orders if it has one. If I try to do this:

select P.NAME, C.NAME, SUM(O.AMOUNT)
from PRODUCT P, CLIENT C, ORDER O
where P.ID = O.PRODUCT_ID(+) and
C.ID = O.CLIENT_ID(+)

I get an error where I cannot double outer join a table.

Any ideas?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2012
Added on Sep 12 2012
10 comments
2,620 views