日期:2014-05-17 浏览次数:20623 次
select a.[单位],count(1) from [坐落表] a ,[分栋表] b where a.[坐落编号]=b.[坐落编号] and [是否空闲]='Y' group by a.[单位]