Joins Information Required

[phpprogrammer]

Dear All,

Can any one suggest/give some detaild notes on sql joins and the differences between them

if differences between leftjoin, rightjoin, equijoin, self join, cartesian join, heap join, outer join

regards
bvsureshbabu

[sid]

http://www.mysql.com/doc/en/JOIN.html