ClearServe interview question

What is a join in SQL?