• HI

    Try this method:

    SELECT E1.Place, E1.Objective,E1.Year,E1.Month,E1.Exam1, E2.Exam2,E3.Exam3

    FROM #tmpExam1 E1

    inner join #tmpExam2 E2 on E1.objective = E2.objective

    inner join #tmpExam3 E3 on E1.objective = E3.objective