update a --用别名
set
preamt=b.curamt
from
cardinfo a , cardinfo b
where
a.cardid =b.cardid
and
a.updatedate ='2007-01-01'
and
b.updatedate =dateadd ( dd , - 1 , '2007-01-01' )
set
preamt=b.curamt
from
cardinfo a , cardinfo b
where
a.cardid =b.cardid
and
a.updatedate ='2007-01-01'
and
b.updatedate =dateadd ( dd , - 1 , '2007-01-01' )
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货