LEFT JOIN and RIGHT JOIN

[Ananda Kumar]

Hi All,
Can u please let me know when should i use LEFT JOIN and when should i going
for a RIGHT JOIN. Please let me know some examples.

regards
anandkl