Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: Difference between LEFT n RIGHT JOIN

    Hi,
    I have got a query for you guys. Can any one temme the difference between

    "FROM Table_A LEFT JOIN Table_B" and "FROM Table_B RIGHT JOIN Table_A"




    Thanks,
    Rahul Jha

  2. #2
    Join Date
    Jun 2003
    Posts
    269

    Cool

    Read Books online
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    There is no functional difference between the two examples you gave. LEFT OUTER JOIN is preferred for clarity and consistency.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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