Smoothstack interview question

What is a Join in SQL and what are they?