Pregunta de entrevista de Almac Group

What is left and right join in SQL?