如下语句
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里面却提示:不支持连接表达式。
到底是哪里的问题呢?
谢谢!
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里面却提示:不支持连接表达式。
到底是哪里的问题呢?
谢谢!
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
2.用where 可以实现
3.order by 不能用新列别名,可以用聚合函数或列顺序号