Difference b/w Inner and outer join

[ERUM]

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

[kaffenils]

INNER JOIN returns rows from the joined tables where the join comparison operator of the columns match. Keep in mind that you don't have to specify = in the join expressions. You can use other comparison operators, like >=,<=, >,<, BETWEEN, <>, LIKE, IN +++

A LEFT OUTER JOIN (the same as LEFT JOIN) returns all rows from the left table in the expression and only the matching rows in the right table.