Question

oracle 表a的一行存的是另一个表b列的id，怎么查询表a时怎么转换成id对应的值

例如：
表a一行：id,pid1,pid2,pid3...
表b：pid1,name1
pid2.name2
pid3,name3
.....
查表a想得出结果为id,name1,name2,name3...
请教应该怎么操作？

Answer 1

select a.id , (select b.name1 from 表b b where b.pid1 = a.pid1) name1,(select b.name2 from 表b b where b.pid2 = a.pid2) name2,(select b.name3 from 表b b where b.pid3 = a.pid3) name3 from 表a a

Answer 2

select a.id,p1.name1,p2.name2,p3.name3 from 表a as a,表b as b1,表b as b2,表b as b3 where
a.pid1=b1.pid1 and
a.pid2=b2.pid2
a.pid3=b3.pid3