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