A/c to definition:

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


I have find some where that difference b/w these two is
"outer join is used between the two tables .inner join is used with in the table."
but i think inner join is also used b/w two tables

comments required from members