更新时间:2023-01-23 11:07:35
尝试一下:
UPDATE table_1 tb1,
table_2 tb2,
table_3 tb3
SET tb1.field2 = "some value",
tb2.field3 = "some other value",
tb3.field4 = "some another value"
WHERE tb1.field1 = tb2.field1
AND tb1.field1 = tb3.field1
AND tb1.field1 = "value"
我在MSAccess和SQL SERVER 2008上测试了代码
I tested the code on MSAccess and SQL SERVER 2008