首先你的A,B表要有关连字段,如ID
select sum(balance) from table a,b
where t.date between B.begin_date and B.end_date and A.ID=B.ID
Group by t.id,t.class
select sum(balance) from table a,b
where t.date between B.begin_date and B.end_date and A.ID=B.ID
Group by t.id,t.class
select sum(balance) from table a,b
where a.date between B.begin_date and B.end_date
如果B表有多条记录select B.begin_date,B.end_date,sum(balance) from table a,b
where a.date between B.begin_date and B.end_date
group by B.begin_date,B.end_date