Pergunta de entrevista da empresa PNC Financial Services Group

SQL: the difference between join and union, left join and inner join