Dayforce interview question

Explain how JOIN works in SQL.