select T2.db_ID1,T1.name as db_mc,T2.db_ID2,T2.ID1,T3.name as mc,T2.ID2
from T2, T2 T3, T1
where T2.db_ID1=T1.ID1 and T3.ID1=T1.Id1;
或者
select T2.db_ID1,(select name from T1 where ID1=T2.db_ID1) db_mc, T2.db_ID2,
T2.ID1,(select name from T1 where ID1=T2.ID1) mc, T2.ID2
from T2;