Smoothstack Interview Question

What is a Join in SQL and what are they?