LEFT OUTER JOIN / LEFT JOIN returns all of the rows from LEFT table and the corresponding matching rows from the right table. RIGHT OUTER JOIN / RIGHT JOIN returns all the rows from the RIGHT table and the corresponding matching rows from the left table. If table does not have matching record then NULL value assigned for that column.