select shisProperty.UsePurpose,shisFloors.FloorName,count(shisProperty.ID)as ts,sum(shisProperty.ArchArea) as mj from shisProperty,shisFloors where shisProperty.BuildingID=[BUILDID] and shisProperty.FloorID=shisFloors.ID GROUP BY shisFloors.FloorName,shisProperty.UsePurpose,shisFloors.FloorNo order by shisFloors.FloorNo
全部评论