计算总值

niuqinrong 发布于 2008-04-19 18:06， 461 次点击

奖励表
number    name    prize   date
1          张三    1000    20080415
2          张三     500     20080416
3          张三     600     20080417
员工表
u_number  name   prize    date
28        张三             200804

请问怎样把奖励表中，张三在2008年4月的奖励计算出来，然后插到员工表，中张三的记录中去啊？？？

3 回复

tianyu1232008-04-19 18:14

Select sum(prize) as num from 奖励表 where [name]='张三' and [date] like '%200804%'

niuqinrong2008-04-19 18:32

那怎样插入到员工表中去呢？

tianyu1232008-04-20 12:00

set rs=conn.execute("Select sum(prize) as num from 奖励表 where [name]='张三' and [date] like '%200804%'")

conn.execute("update 员工表 set prize="& rs("num") &" where [name]='张三' and [date] like '%200804%'")