为什么Access不支持呢？

如下语句
Select [Name] as sUnit, count(*) as sTime from Cl_BreakRecord inner join Cl_Group On GroupID = Cl_Group.ID and DepartmentID = 3 group by [Name] order by sTime desc

在sql里测试时没有问题的
而在access里面却提示：不支持连接表达式。
到底是哪里的问题呢？
谢谢！

---

access學習~~~

---

引用

access學習~~~

up

---

SQL code:
--try
Select
[Name] as sUnit, count(*) as sTime
from
Cl_BreakRecord ,Cl_Group
where
GroupID = Cl_Group.ID
and
DepartmentID = 3
group by
[Name]
order by
sTime desc

---

纳闷了，明明access也支持 inner join 的

---

1.join 不支持列名与常数的连接 支持列名与列名的连接
2.用where 可以实现
3.order by 不能用新列别名，可以用聚合函数或列顺序号

---

thanks!

---

语法不支持呀