Difference b/w Inner and outer join

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

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.