Pergunta de entrevista da empresa Manulife

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