更新的这样就可以了。插入的不用变。
update logontotal set logontotal.logoncount=logontotal.logoncount+logondayly.logoncount
from logondayly,logontotal
where logondayly.userid=logontotal.userid and logondaily.isnewuser =0 and DATEDIFF(day, THETIME, getdate())=0
update logontotal set logontotal.logoncount=logontotal.logoncount+logondayly.logoncount
from logondayly,logontotal
where logondayly.userid=logontotal.userid and logondaily.isnewuser =0 and DATEDIFF(day, THETIME, getdate())=0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货