Pregunta de entrevista de IQVIA

What is SQL join explain in details