想请各位帮我看一下这个

宋海波发布于 2013-01-15 15:36， 500 次点击

update T_medstore,T_TksMedRec set t_medstore.kcsl=T_TksMedRec.kcsl where t_medstore.ypdm=T_TksMedRec.ypdm and
T_TksMedRec.rq between '2013-01-14 00:00:00.000' and '2013-01-15 00:00:00.000' and T_medstore.ypdm='501916'

哪个大哥，帮我看一下这个哪里错了两个表 T_medstore T_TksMedRec 我想把T_medstore的kcsl= T_TksMedRec的kcsl

3 回复

cnfarer2013-01-16 06:30

from T_TksMedRec

半杯清茶2013-01-16 16:01

update t1 set t_medstore.kcsl=T_TksMedRec.kcsl
from T_medstore t1 inner join T_TksMedRec t2 on t1.ypdm=T2.ypdm
where t2.rq between '2013-01-14 00:00:00.000' and '2013-01-15 00:00:00.000'
and t1.ypdm='501916'

试试

xiaolee2013-03-15 11:20

支持3楼写的