Manulife interview question

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