In SQL, the left join returns all the records from first table and matched records from second table. ... Basically there is no difference in left join and left outer join. Left outer join also returns same results as left join. In some database, left join is known as left outer join.