当我在ACCESS 2007中运行以下sql时
Select Location,
COUNT(ApartmentBuildings) AS
TotalIBuildingsManaged From Apartments
Where COUNT(ApartmentBuildings) > 3
Group By Location Order By
COUNT(ApartmentBuildings) DESC;
我收到以下错误：
解决方法
使用而不是在哪里：
Select Location,COUNT(ApartmentBuildings) AS TotalIBuildingsManaged From Apartments Group By Location Having COUNT(ApartmentBuildings) > 3 Order By COUNT(ApartmentBuildings) DESC;
了解更多信息see this page
