difference between (left, right, inner, outer) join?

[Rhishabh07]

difference between (left, right, inner, outer) join?

anybody can help me?

Thanx

[code green]

When joining two tables

table1 JOIN table2

This is MySql shorthand for INNER JOIN.
If no recordset is returned from table1 then the whole query returns nothing.
But if you specify RIGHT JOIN then table2 will still return its asked for recordset.
And vice versa for LEFT JOIN.
At least that the way it seems to work for me.

[fundakid]

difference between (left, right, inner, outer) join?

anybody can help me?

Thanx

I do not remember where I saw it first on the web, but here is a reproduction of the BEST explanation I know that explains the different types of JOINS. Here it is. Hope this helps you.