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

Rhishabh07

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

anybody can help me?

Thanx

Jul 12 '07 #1

code green

When joining two tables 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.

Jul 12 '07 #2

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.

Sep 11 '07 #3