UPDATE 语句问题

rmb

免费乐捐，感谢支持

请问这个语句哪里不对？

update A, B set B.a = 0 where A.a = 'ZZZ' and A.b = B.b and B.b not like '%Y%'

JohnPhan

缺少FROM 部分

rmb

請問這個語句的該怎麼樣加From部分呢?

謝謝!

xxgsymj

update A, B set B.a = 0
from A,B...ft
where A.a = 'ZZZ' and A.b = B.b and B.b not like '%Y%'


update table1 set col1=0
from table1,table2
where table1.col1='zzz' and table1.coln=table2.coln and table2.coln not like'%Y%'
思路应该是这样吧
具体没搞。。
错了别骂。。^_^

njusheep

you just can write the SQL statement like this:

update B set B.a = 0 where A.a = 'ZZZ' and A.b = B.b and B.b not like '%Y%'

A is forbidden to apear between 'update' and 'set'.