select a.学校名,count(*) 数量 from a,b where a.学校名=b.学校名 group by a.学校名
select 名称,count(b.字段) from a,b where a.学校=b.学校 group by 学校到数据库区看看
group by和order by冲突了
要order by排序的 还有count()怎么弄到GridView里去
SELECT a.ID, a.ClassN, a.SchoolN, a.KeyWord, a.Leader, a.Tel, a.email, a.Coach, a.regtime, count(a.ID) FROM [school] a, [model] b where a.ID=b.SchoolID group by a.ID, a.ClassN, a.SchoolN, a.KeyWord, a.Leader, a.Tel, a.email, a.Coach, a.regtime 好像不太对
declare @t table(id int, SchoolN nvarchar(100)) insert @t values(1,'jia') insert @t values(2,'yi') insert @t values(3,'bing') insert @t values(4,'ding') --select * from @t -------------------------------------------------- declare @b table (id int, SchoolID int, ItemName nvarchar(500)) insert @b values(1,1,'jia_schoole_Tangjial') insert @b values(2,1,'jia_schoole_ShDl') insert @b values(3,2,'yi_schoole_TianGang') insert @b values(4,2,'yi_schoole_l') insert @b values(5,2,'yi_schoole_hongLingjin') insert @b values(6,3,'bing_schoole_fengNiao') insert @b values(7,4,'ding_schoole_tianAnmen') --select * from @b select t.SchoolN,count(b.itemName) as countitem from @t t,@b b where t.id=b.SchoolID group by t.SchoolN order by t.SchoolN 写的一个sql,order by没有冲突 貌似在你的access中是冲突的.
在选定的数据源上未找到名为“count(*)”的字段或属性。
你count(a.ID) as 一个字段啊 我上面不是: count(b.itemName) as countitem 就可以在页面绑定了 Eval("countitem")
很少用access
应该也有分组汇总吧
b:ID SchoolID ItemName
from a,b
where a.学校名=b.学校名
group by a.学校名
from a,b
where a.学校=b.学校
group by 学校到数据库区看看
还有count()怎么弄到GridView里去
FROM [school] a, [model] b
where a.ID=b.SchoolID
group by a.ID, a.ClassN, a.SchoolN, a.KeyWord, a.Leader, a.Tel, a.email, a.Coach, a.regtime
好像不太对
insert @t values(1,'jia')
insert @t values(2,'yi')
insert @t values(3,'bing')
insert @t values(4,'ding')
--select * from @t
--------------------------------------------------
declare @b table (id int, SchoolID int, ItemName nvarchar(500))
insert @b values(1,1,'jia_schoole_Tangjial')
insert @b values(2,1,'jia_schoole_ShDl')
insert @b values(3,2,'yi_schoole_TianGang')
insert @b values(4,2,'yi_schoole_l')
insert @b values(5,2,'yi_schoole_hongLingjin')
insert @b values(6,3,'bing_schoole_fengNiao')
insert @b values(7,4,'ding_schoole_tianAnmen')
--select * from @b
select t.SchoolN,count(b.itemName) as countitem
from @t t,@b b
where t.id=b.SchoolID
group by t.SchoolN
order by t.SchoolN
写的一个sql,order by没有冲突
貌似在你的access中是冲突的.
我上面不是: count(b.itemName) as countitem
就可以在页面绑定了 Eval("countitem")
这里看一下group by, order by