UPDATE WRK_Housyuuteigaku INNER JOIN MST_SYAIN ON WRK_Housyuuteigaku.职员编号 = MST_SYAIN.职员编号
SET MST_SYAIN.报酬月额 = WRK_Housyuuteigaku.标准月额

这句话哪错了？要想实现怎么改？

UPDATE MST_SYAIN SET 报酬月额 = WRK_Housyuuteigaku.标准月额 from MST_SYAIN
INNER JOIN WRK_Housyuuteigaku ON WRK_Housyuuteigaku.职员编号 = MST_SYAIN.职员编号

你连SQL最基本的语法规则都没弄清楚 先好好看书吧

为什么这么写？什么规则？

看看书就知道了

[ WITH <common_table_expression> [...n] ]
UPDATE
[ TOP ( expression ) [ PERCENT ] ]
{ <object> | rowset_function_limited
[ WITH ( <Table_Hint_Limited> [ ...n ] ) ]
}
SET
{ column_name = { expression | DEFAULT | NULL }
| { udt_column_name.{ { property_name = expression
| field_name = expression }
| method_name ( argument [ ,...n ] )
}
}
| column_name { .WRITE ( expression , @Offset , @Length ) }
| @variable = expression
| @variable = column = expression [ ,...n ]
} [ ,...n ]
[ <OUTPUT Clause> ]
[ FROM{ <table_source> } [ ,...n ] ]
[ WHERE { <search_condition>
| { [ CURRENT OF
{ { [ GLOBAL ] cursor_name }
| cursor_variable_name
}
]
}
}
]
[ OPTION ( <query_hint> [ ,...n ] ) ]
[ ; ]

<object> ::=
{
[ server_name . database_name . schema_name .
| database_name .[ schema_name ] .
| schema_name .
]
table_or_view_name}

谁能吧这些参数都翻译一下啊？