Select查询问题
一直开发ASP.NET + access 因需要而转成SQL，在ACCESS中 下列的代码没有报错的，但在SQL里就报错，
显示：关键字 'Group' 附近有语法错误。
Select [ban],Sum([Count]) from (
Select left([Class],2) as [ban],count(*) From [Point_Record] Where [Disponse] like '-%' group by [ban]
) Group by [ban] Order by Sum([Count]) Desc
求高手为小弟解答~
关键是 两个 select 不行
下面的又错在哪了？
Select sum(shu) from（select count(*) as [shu] From [Teacher] Where [Status] = 1 union all Select count(*) as [shu] From [Student] Where [Status] = 1）
[解决办法]
Select [ban],Sum([Count]) from (
Select left([Class],2) as [ban],count(*) From [Point_Record]
Where [Disponse] like '-%' group by left([Class],2)
) AS T Group by [ban] Order by Sum([Count]) Desc
[解决办法]
Select sum(shu) from（select count(*) as [shu] From [Teacher] Where [Status] = 1 union all Select count(*) as [shu] From [Student] Where [Status] = 1） AS T
[解决办法]
Select [ban],Sum([Count]) from (
Select left([Class],2) as [ban],count(*) From [Point_Record] Where [Disponse] like '-%' group by [ban]
) 加个别名，如a Group by [ban] Order by Sum([Count]) Desc
Select sum(shu) from（select count(*) as [shu] From [Teacher] Where [Status] = 1 union all Select count(*) as [shu] From [Student] Where [Status] = 1）a
[解决办法]
Select left(Class,2) ban , count(*) [count] From Point_Record Where Disponse like '-%'Group by left(Class,2)Order by [count] Desc
