我有两张table finance_mpc_budget 以及 finance_mpc_issues . 它们的连接条件如下-

finance_mpc_budget.mpc_budget_id = finance_mpc_issues.ref_no

所以，我需要更新 finance_mpc_issues.ref_no 使用

finance_mpc_budget.mpc_budget_id where finance_mpc_budget.mpc_budget_id > 55

为此，我使用了以下查询

UPDATE finance_mpc_issues 
JOIN (
      SELECT mpc_budget_id FROM finance_mpc_budget
      WHERE finance_mpc_budget.mpc_budget_id > 55 
      ORDER BY mpc_budget_id) a 
ON a.mpc_budget_id = finance_mpc_issues.ref_no 
SET finance_mpc_issues.ref_no = a.mpc_budget_id

但它生成了空的结果集。可能出了什么问题。有人能帮我吗？

财政部预算表

+---------------+----------+--------+
| mpc_budget_id | category | amount |
+---------------+----------+--------+
|             56| A        |  22000 |
|             57| B        |  25000 |
|             58| C        |  45000 |
|             59| D        |  16000 |
+---------------+----------+--------+

财政政策委员会议题表

+-----------+--------+--------+
| issues_id | ref_no | amount |
+-----------+--------+--------+
|        10 |        |  22000 |
|        11 |        |  25000 |
|        12 |        |  45000 |
|        13 |        |  16000 |
+-----------+--------+--------+

期望输出

+-----------+--------+--------+
| issues_id | ref_no | amount |
+-----------+--------+--------+
|        10 |      56|  22000 |
|        11 |      57|  25000 |
|        12 |      58|  45000 |
|        13 |      59|  16000 |
+-----------+--------+--------+