StreetLight Data interview question

What does a join do in SQL?