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

from T_TksMedRec

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'


试试

支持3楼写的