Question d’entretien chez Manulife

Explain SQL join functions conceptually, describing inner, left, right, and full joins