INNER JOIN and outer join

An inner join connects only matching rows

The left OUTER join contains all rows from the table on the left (regardless of whether there are rows in the right table that match them), and all rows in the right table

A LEFT join B is equivalent to a left outer join B

The right outer join contains all rows from the right table (regardless of whether there are rows in the left table that match them), and all rows in the left table

A Right Join B

A full outer join contains all rows from the left and right two tables, regardless of whether there are rows in the other side of the table that match them. A full outer JOIN B

Cases:

SELECT column_name (s)from fullJOIN on table_name1.column_name= Table_name2.column_name

INNER JOIN and outer join