select t2_1.Name,t2_2.Name,t2_3.Name,t2_4.Name,t2_5.Name,t2_6.Name,t2_7.Name from t1 left join t2 t2_1 on t1.ID1 = t2_1.ID left join t2 t2_2 on t1.ID2 = t2_2.ID left join t2 t2_3 on t1.ID3 = t2_3.ID left join t2 t2_4 on t1.ID4 = t2_4.ID left join t2 t2_5 on t1.ID5 = t2_5.ID left join t2 t2_6 on t1.ID6 = t2_6.ID left join t2 t2_7 on t1.ID7 = t2_7.ID
from t1
left join t2 t2_1 on t1.ID1 = t2_1.ID
left join t2 t2_2 on t1.ID2 = t2_2.ID
left join t2 t2_3 on t1.ID3 = t2_3.ID
left join t2 t2_4 on t1.ID4 = t2_4.ID
left join t2 t2_5 on t1.ID5 = t2_5.ID
left join t2 t2_6 on t1.ID6 = t2_6.ID
left join t2 t2_7 on t1.ID7 = t2_7.ID