同时更新多个表里的字段
update table1 ta1
table2 ta2
table3 ta3
set ta1.value1 = '1 ',ta2.value1 = '1 ',ta3.value2 = '0 '
where ta1.value1 = ta1.value1
and ta1.value2 = ta2.value2
and ta1.value1 = ta3.value1
有没有实现这样功能的SQL语句?上边的语句跑不通,只是个想象的样子...
(同时更新多个表,而且这几个表间字段有关联)
[解决办法]
不能这样执行,只能
update table1 set ta1.value1 = '1 '
from table1 ta1 ,table2 ta2,table3 ta3
where ta1.value1 = ta1.value1
and ta1.value2 = ta2.value2
and ta1.value1 = ta3.value1
