Pergunta de entrevista da empresa Almac Group

What is left and right join in SQL?