James interview question

Differences in SQL left join, inner join, union