update table1 set table1.code = 100 from table1 a,table2 b,table3 c where a.key = c.key a.no = b.no a.key = c.key a.code = 10 b.tor = 'THE' a.group = 4183 a.no in ('1111','1331','1345')
我得到通用的-201’发生语法错误’消息,但我看不出有什么问题.
set table1.code = 100
将此更改为
set a.code = 100
完整代码
update table1 set a.code = 100 from table1 a,table3 c where a.key = c.key and a.no = b.no and a.key = c.key and a.code = 10 and b.tor = 'THE' and a.group = 4183 and a.no in ('1111','1345')
