On Thu, 06 Mar 2008 09:41:16 -0800, Damodhar wrote:

> please help me
>
> can u give the simple definition's
>
>
> what is the deference between JOIN & INNER JOIN /OUTER JOIN and LEFT
> JOIN /RIGHT JOIN
>
>
> please help me i filly confused..

JOIN and INNER JOIN are the same. They display the rows for the left
table once for each matching row in the right table, and the other way
around.

a LEFT (OUTER) JOIN shows all of the output rows from the INNER JOIN,
plus if any rows from the left table do not have matching records from
the right table, it's added with the rows from the right table replaced
by NULL

a RIGHT (OUTER) JOIN does the same, but adding the extra rows from the
right table only

a (FULL) OUTER JOIN shows the extra rows from both tables.

Hope that helps...


--
Remove caps to reply