ALTEN interview question

Come si usa una Join in SQL