Dayforce Interview Question

Explain how JOIN works in SQL.