Mysql Joins information required

[phpprogrammer]

Dear All,

plz Any one give the informaion about the joins

ie when(on which conditions/situations) we have to use left joins, right joins

i am littele bit about the joins

regards
bvsureshbabu

[barand]

Use joins when you need to get related data from more than one table.

A normal (INNER) JOIN gets the data from both tables where the fields used in the join have a matching value in both tables.

If you want data from table A even when there is no match in table B use 'A LEFT JOIN B' (or less commonly, 'B RIGHT JOIN A')

hth