update T_UserInfo set Result='0',Remarks=B.Remarks from UserInfo A WITH(NOLOCK),T_DianHuaYingXiao B WITH(NOLOCK) where A.Result='8' and B.ZuoXi='"+pZuoXi+"' and B.Flag_Done!='1' and (B.Flag_TongYi='1' or B.Flag_TongYi='4') and A.Mobile=B.Mobile
update后面跟from语句
最新推荐文章于 2024-04-12 15:43:28 发布