Pergunta de entrevista da empresa Cox Communications

Can you explain different types of joins in SQL?