Cox Communications Interview Question

Can you explain different types of joins in SQL?