UPDATE tblAppraisalBasicData
SET tblAppraisalBasicData.ISCbo=1
FROM tblAppraisalBasicData SI INNER JOIN  aaa_test RAN ON SI.EmpID = RAN.ID

SQL不是真正可移植的另一个例子。

对于MySQL，应该是：

update ud, sale
set ud.assid = sale.assid
where sale.udid = ud.id;

有关更多信息，请阅读多表更新：http://dev.mysql.com/doc/refman/5.0/en/update.html

UPDATE [LOW_PRIORITY] [IGNORE] table_references
    SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
    [WHERE where_condition]

对于使用MySQL 5.7的prestashop用户

UPDATE
    ps_stock_available sa
    INNER JOIN ps_shop s
        ON sa.id_shop = s.id_shop AND s.id_shop = 1
    INNER JOIN ps_order_detail od
        ON sa.id_product = od.product_id AND od.id_order = 22417
SET
    sa.physical_quantity = sa.quantity + sa.reserved_quantity

这是一个例子，但重点正如埃里克在这里所说https://stackoverflow.com/a/1293347/5864034

您需要在FIRST处添加UPDATE语句，其中包含要连接的所有表的完整地址，然后添加SET语句

Teradata Aster提供了实现目标的另一种有趣方式：

MERGE INTO ud --what table should be updated
USING sale -- from what table/relation update info should be taken
ON ud.id = sale.udid --join condition
WHEN MATCHED THEN 
    UPDATE SET ud.assid = sale.assid; -- how to update

试试这个吧，我想这对你有用

update ud

set ud.assid = sale.assid

from ud 

Inner join sale on ud.id = sale.udid

where sale.udid is not null

这在SQL Server中应该有效：

update ud 
set assid = sale.assid
from sale
where sale.udid = id