Question d’entretien chez Sokrati

What are left join & right join (SQL)?