RBC interview question

What does a SQL JOIN do?