Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    25

    Unanswered: Difference in Left Outer and Right Outer Join

    We all knows the difference between a Left and Right Outer Join,
    Lets says we have two tables A and B.
    A a Left Outer Join B b On (a.id =b.id)

    This means all record from table A will be displayed even if there's not a matching record in Table B.

    Now if I want a right Outer Join betwee A and B, then instead of using a Right Outer Join I can get the same result using the below query
    B b Left Outer Join A a On (b.id =a.id).

    So why there's a need of right Outer join, if the same can be achieved using a Left Outer Join?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by alirulez999 View Post
    So why there's a need of right Outer join, if the same can be achieved using a Left Outer Join?
    that's a good question
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •