有两张表yxzb(存放学生基本信息)和zcb(存放缴费情况),我想在DBGrid中按学院统计收费信息:
学院名称 总人数 已缴费人数 缴费金额
于是我写了如下语句: select b.xymc,a.count(*) as zrs,b.count(*) as yjrs,b.sum(je) as zje from yxzb as a,t_bxywb as b group by b.xymc 其中xymc为学院名称,je为金额。
哪位大虾能帮忙看看吗?先谢谢了
学院名称 总人数 已缴费人数 缴费金额
于是我写了如下语句: select b.xymc,a.count(*) as zrs,b.count(*) as yjrs,b.sum(je) as zje from yxzb as a,t_bxywb as b group by b.xymc 其中xymc为学院名称,je为金额。
哪位大虾能帮忙看看吗?先谢谢了
我一般用是group by 后面加上所以没有sum的就好了
inner join t_bxywb b on a.id=b.id
group by b.xymc
请把 yxzb(存放学生基本信息)和zcb(存放缴费情况)表结构贴出,
他们是什么关系!
select b.xymc,a.count(*) as zrs,b.count(*) as yjrs,b.sum(je) as zje from yxzb as a,t_bxywb as b group by b.xymc---------
上面这句话,两表是用什么关联呀
inner join t_bxywb b on a.id=b.id
group by b.xymc