如何写sql的更新语句

发布网友

我来回答

共5个回答

热心网友

update Table1 set Field3=(select Field3 from Table2) where Table1.Field1=Table2.Field1;

热心网友

UPDATE Table2 SET Field3 = B.Field3
FROM Table2 A INNER JOIN Table1 B ON A.Field1 = B.Field1

热心网友

UPDATE Table1 SET Field3 = B.Field3
FROM Table1 A ,Table2 B
where A.Field1 = B.Field1

热心网友

应该用到触发器啥的吧，两个表关联下

热心网友

update table1 from table1.field3=table.field3