Pregunta de entrevista de Tata Consultancy Services

Explain the SQL Join query?