Differences between Inner join and outer join

[Former Member]

Please any one tell what are the differences between Inner join and Outer join plz tell me

points will be rewarded

[Former Member]

You use INNER JOIN to return all rows from both tables where there is a match. ie. in the resulting table all the rows and colums will have values.

In OUTER JOIN the relulting table may have empty colums. Outer join may be either LEFT or RIGHT

LEFT OUTER JOIN returns all the rows from the first table, even if there are no matches in the second table.

RIGHT OUTER JOIN returns all the rows from the second table, even if there are no matches in the first table.

Outer Join:

There are three types of outer joins namely:

Left Outer Join---For retreiving all the columns from the first table irrespective of the column match.

Right Outer Join---For retreiving all the columns from the second table irrespective of the column match

Full Outer Join---For retreiving all the columns from both the tables irrespective of column match.