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!

Using multiple JOINS on the same table

748490Jun 21 2010 — edited Jun 21 2010

Hi All,

I'm running the following query:

SELECT
    a.id_number, 
    b1.value as value1, 
    b2.value as value2, 
    b3.valuse as value3
FROM
   alpha a
   left join beta b1 on (a.id_number = b1.id_number and b1.type = 1001)
   left join beta b2 on (a.id_number = b2.id_number and b2.type = 1002)
   left join beta b3 on (a.id_number = b3.id_number and b3.type = 1003)

Is there a more efficient way to construct this query, wihtout using multiple joins?

Thanks,

Valerio

Edited by: valerio75 on 21-Jun-2010 01:36

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2010

Added on Jun 21 2010

#query, #sql

10 comments

6,747 views