Question d’entretien chez Cushon

Can you explain the differences between all the available joins in SQL?