对于使用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

PostgreSQL：

CREATE TABLE ud (id integer, assid integer);
CREATE TABLE sales (id integer, udid integer, assid integer);

UPDATE ud
SET assid = sales.assid
FROM sales
WHERE sales.id = ud.id;

对于使用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语句

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

使用JOIN多个表简化更新查询。

   UPDATE
        first_table ft
        JOIN second_table st ON st.some_id = ft.some_id
        JOIN third_table tt  ON tt.some_id = st.some_id
        .....
    SET
        ft.some_column = some_value
    WHERE ft.some_column = 123456 AND st.some_column = 123456

请注意，first_table、second_table、third_table和123456这样的some_column是演示表名、列名和id。用有效名称替换它们。