土地分摊SQL语句怎么写

不知道，你这得问专业的人，我们这些半吊子搞不来。

要看你怎么分摊，bmf软件里只有占地面积

SELECT Bld.BldNO,Cll.CellName,Flr.FloorName,Rm.DoorNo,Rm.SetInArea,Rm.AppArea,AC.AppCoeff,Rm.ArchArea,Rm.UsePurpose,viewShapeHouseNanCheng.FTTDMJ,CASE WHEN 1 = 0 THEN '' ELSE '' END AS KONG,Rm.Remark FROM shisproperty Rm INNER JOIN shisEntities Ent ON Ent.OwnerID = Rm.ID LEFT OUTER JOIN shisbuildinf Bld ON Rm.BuildingID=Bld.ID LEFT OUTER JOIN shisfloors Flr ON Rm.FloorID=Flr.ID LEFT OUTER JOIN shiscells Cll ON Ent.CellID=Cll.ID LEFT OUTER JOIN shisappcoeff AC ON Rm.AppcoeffID=AC.ID LEFT JOiN viewShapeHouseNanCheng ON viewShapeHouseNanCheng.HID = Rm.ID WHERE(Ent.IsPubUse=0) AND (Ent.IsMainEnt=1) AND Rm.BuildingID=[BUILDID] ORDER BY Bld.BldNO,Flr.FloorNO,Cll.CellName,Rm.DoorNO

看看哪里要修改

你这个是定制版的软件里，里面的视图不是标准版有的