SELECT shisProperty.FloorName,replace(shisProperty.cellno,'0',' ') as dy, viewBmfRoom2.doorno, viewBmfRoom2.tnmj, viewBmfRoom2.appcoeff, viewBmfRoom2.ftmj, viewBmfRoom2.ytmj, viewBmfRoom2.zmj, shisProperty.UsePurpose,shisproperty.OutOrder,shisfloors.id
FROM viewBmfRoom2,shisfloors,shisproperty
WHERE viewBmfRoom2.bldid =[BUILDID] and viewBmfRoom2.flrid = shisfloors.id and shisproperty.id =viewBmfRoom2.proid order BY shisproperty.OutOrder,shisfloors.id
全部评论