7 Replies Latest reply on Jul 26, 2010 5:12 PM by 6363

    Why Left and Right Joins if only one of them can serve the same purpose?

    787326
      I understand that left join is used to display all the records from left table whereas the right join is used to display all the records from right table in a join.
      However, if we switch the positions of the join tables and perform left join we can get all the records of the left table.

      A left join B -> will give all records from A
      A right join B ->will give all records from B

      B left join A -> will again give all records from B.

      The order in which the data is displayed(ie the field order) can also be maintained in the SELECT clause.

      So, Why do we have left and right joins separately in existance, when only one of them can serve the same purpose?