Question d’entretien chez Almac Group

What is left and right join in SQL?