Revature Interview Question

Can you tell me about joins in SQL?