我有个table, TPINS里面有几个colums:
YouthFK
MomFK
DadFK
这几个colums分别是另一个表TPerson的FK我现在想select这几个FK,并把Tperson里面和这几个FK相同的数据调出来,但需要返回成一行(Row),怎么实现阿?
YouthFK
MomFK
DadFK
这几个colums分别是另一个表TPerson的FK我现在想select这几个FK,并把Tperson里面和这几个FK相同的数据调出来,但需要返回成一行(Row),怎么实现阿?
a.YouthFK,
b.otherFiled,
a.MomFK,
c.otherFiled,
a.DadFK,
d.otherFiled
from TPINS a left join Tperson b on a.YouthFK=b.YouthFK
left join Tperson c on a.MomFK=c.YouthFK
left join Tperson d on a.DadFK=d.DadFK
(select field from Tperson where MomFK=a.MomFK) as field2
from TPINS a