select (select name from T1 where id=a.p1) as n1
,(select name from T1 where id=a.p2) as n2
,(select name from T1 where id=a.p3) as n3
from T2
,(select name from T1 where id=a.p2) as n2
,(select name from T1 where id=a.p3) as n3
from T2
left join T1 B on A.p1= B.id
left join T1 C on A.p2= C.id
left join T1 D on A.p3= D.id
,(select name from T1 where id=a.p2) as n2
,(select name from T1 where id=a.p3) as n3
--into T3 --如果要生成T3这个表,就去掉本行前面的注释:--
from T2 a
select (select name from T1 where id=T2.p1) n1,(select name from T1 where id=T2.p2) n2,(select name from T1 where id=T2.p3) n3 from T2--得到T3新表:
select (select name from T1 where id=T2.p1) n1,(select name from T1 where id=T2.p2) n2,(select name from T1 where id=T2.p3) n3 into T3 from T2
from t2 left join t1 on t2.p1=t1.id
left join t1 aa on t2.p2=aa.id
left join t1 bb on t2.p3=bb.id
select char(64+p1) as n1,char(64+p2) as n2,char(64+p3) as n3 from t2