请问在图形模板中加入单元名 产权性质 图幅号这仨个该怎么关联语句

产权性质   select shisBuildInf.PrpRightKind from shisBuildInf where shisBuildInf.ID=[BUILDID]

图幅号

 SELECT shisBuildInf.ArchArea,  shisFinallot.MapNo FROM shisFinallot right join shisBuildInf on shisBuildInf.LotNO=shisFinallot.LotNO WHERE shisBuildInf.ID = [BUILDID]

分户图单元名称：

select DISTINCT shiscells.cellname from shiscells,shisentities ,shisproperty where shiscells.id=shisentities.cellid and shisentities.ownerid=shisproperty.id and shisproperty.id=[ROOMID]