CODEWITHSUNDEEP
oracle-databaseouter-join
Sandeep Reddy K.
Sandeep Reddy K.

Reputation: 1011

Left outer join on three tables

I need to use left outer join on three table. Example I have three table called A,B and C. I want result like A left outer join ( B left outer join c). What is the best way to do it.

I have written something like this.

select * from A,B,C where A.column_a=B.column_a(+) and B.column_b=C.column_b(+);

Upvotes: 0

Views: 145

Answers (1)

Charles Bretana
Charles Bretana

Reputation: 146409

depending on how the tables are related (which is not entirely clear from your question),

 select * 
 from A
    left join B on b.column_a = a.column_a
    left join C on c.column_b = b.column_b

or,

 select * 
 from A
    left join (B left join C on c.column_b = b.column_b)
        on b.column_a = a.column_a

Upvotes: 1

Related Questions