1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

What's the difference of those types of JOINs?

Discussion in 'SQL PL/SQL' started by NikoTrend1, Apr 1, 2014.

  1. NikoTrend1

    NikoTrend1 Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    How can I correct one of this to take a similar result?
    FIRST:
    Code (Text):

    Select * from tab1
                    left join tab2 on tab1.ID=tab2.ID
                    left join tab3 on tab2.ID=tab3.ID
                    left join tab4 on tab3.ID=tab4.ID;
     
    SECOND:
    Code (Text):

    Select * from tab1
                    left join tab2 using(ID)
                    left join tab3 using(ID)
                 left join tab4 using(ID);
     
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Second :natural_join
     
    NikoTrend1 likes this.