full outer join vs left join in sql

SQL LEFT JOIN or LEFT OUTER JOIN returns all rows from the left table and the matching rows from the right table.