Accenture Interview Question

What are joins in SQL? Give examples.