Home Forums SQL Server 2008 SQL Server 2008 - General Struggling on Duplicates while Join Three Table Produce RE: Struggling on Duplicates while Join Three Table Produce
kbhanu15
SSCarpal Tunnel
Points: 4493
More actions
August 12, 2014 at 6:38 am
#1737184
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