正文
#表结构:
#实现将表Test2的name和age字段数据更新到表Test1中,按照id相等的条件
1、SQLServer多表更新方法:
语法:UPDATE { table_name WITH ( [ ...n ] ) | view_name | rowset_function_limited }
SET { column_name = { expression | DEFAULT | NULL } | @variable = expression | @variable = column = expression } [ ,...n ] { { [ FROM { } [ ,...n ] ] [ WHERE ] } | [ WHERE CURRENT OF { { [ GLOBAL ] cursor_name } | cursor_variable_name } ] } [ OPTION ( [ ,...n ] ) ]
例子:update test1set test1.name=test2.name,test1.age=test2.agefrom test1
inner join test2on test1.id=test2.id
2、Oracle 多表更新方法:
语法:UPDATE updatedtable
SET (col_name1[,col_name2...])= (SELECT col_name1,[,col_na