Accenture interview question

What are joins in SQL? Give examples.