UPDATE 怎么不行

ych3000 2011-03-21 02:30:24

TI WEN

update
(select a.* from idc_process As a
Left Join process2_info As b on a.pr_order = b.jmno
Left Join process2 As c on b.pr_no = c.pr_no where c.accept_ok >= '2011-03-11') as tmp
set tmp.pr_inboxcnt = 'NULL', tmp.pr_ok='0', tmp.pr_findate = 'NULL'

为什么不行

...全文

120 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

向良玉 2011-03-22

打赏
举报

[Quote=引用 10 楼 andy_liucj 的回复:]

引用 1 楼 acherat 的回复:

SQL code

update tmp
set tmp.pr_inboxcnt = 'NULL', tmp.pr_ok='0', tmp.pr_findate = 'NULL'
from (select a.* from idc_process As a
Left Join process2_info As b on a.pr_order……
[/Quote]
+1

水向东流时光怎么偷 2011-03-21

打赏
举报

学习一下!

**********************************************
欢迎使用 CSDN 小秘书
http://blog.csdn.net/whowhen21
**********************************************

andy_liucj 2011-03-21

打赏
举报

[Quote=引用 1 楼 acherat 的回复:]

SQL code

update tmp
set tmp.pr_inboxcnt = 'NULL', tmp.pr_ok='0', tmp.pr_findate = 'NULL'
from (select a.* from idc_process As a
Left Join process2_info As b on a.pr_order = b.jmno
Left Join proc……
[/Quote]
+1

gogodiy 2011-03-21

打赏
举报



;with tmp as

(select a.* from idc_process As a   

Left Join process2_info As b on a.pr_order = b.jmno

Left Join process2 As c on b.pr_no = c.pr_no where c.accept_ok >= '2011-03-11')

update tmp set pr_inboxcnt = 'NULL', pr_ok='0', pr_findate = 'NULL'

要么你这么写试试

yangyangxie 2011-03-21

打赏
举报

看语法。。。。

CainLai 2011-03-21

打赏
举报

语法顺序搞错了，其他的写法都是对的……

--小F-- 2011-03-21

打赏
举报

UPDATE语法：

UPDATE TB SET COL=‘XXX’

xyqiqi 2011-03-21

打赏
举报

没这样写过

快溜 2011-03-21

打赏
举报

update 后面跟的是实体表，不是结果集，怎么老有人这样写。

Xiao_Ai_Mei 2011-03-21

打赏
举报

这个肯定不行，限制更新的条件，加在下面。

Mr_Nice 2011-03-21

打赏
举报

这个

不符合语法哦。规则使然...

LZ可以做个循环来逐一处理对应表

AcHerat 元老 2011-03-21

打赏
举报



update tmp

set tmp.pr_inboxcnt = 'NULL', tmp.pr_ok='0', tmp.pr_findate = 'NULL'

from (select a.* from idc_process As a   

Left Join process2_info As b on a.pr_order = b.jmno

Left Join process2 As c on b.pr_no = c.pr_no where c.accept_ok >= '2011-03-11') as tmp