Tuesday, March 27, 2012

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 JhaRead Books online|||There is no functional difference between the two examples you gave. LEFT OUTER JOIN is preferred for clarity and consistency.

No comments:

Post a Comment