Here it is
select t2.c1,t2.c2,t1.c12 as c3,t11.c12 as c4,t111.c12 as c5
from table2 t2
inner join table1 t1 on t1.c10 = t2.c3
left join table1 as t11 on t11.c10 = t2.c4
left join table1 as t111 on t111.c10 = t2.c5
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.