mysql - 多个表的多次查询

Question

Mysql 请求我需要有关需要在三个表之间进行联接的多个请求的帮助。

基本上，请求看起来有点像这样，但我不确定:

SELECT id_order 
FROM order_refund
JOIN ps_orders ON order_refund.id_order = ps_orders.id_order

INSERT INTO order_refund (id_payment_method)
SELECT id_payment_method
FROM payment_method
JOIN order_refund ON order_refund.id_order = RESULT;
## the result of the request from above... I don't know how to do that...

它们在这里:

ps_orders - id_order - INT - payment - VARCHAR (which includes the name of the average repayment ex:paypal...)

payment_method - id_payment_method - INT - name - VARCHAR (includes the name of these refund methods ex:paypal...)

order_refund - id_order - INT - id_payment_method - INT (does not include anything yet)

我想在 id_ payment_method deorder_refund 列中插入一个数值，并将其与关联的退款方法关联起来。

为此我必须，检索 order_refund id_order 并将其与 ps_orders 的 id_order 进行比较，如果它们相同，则我检索关联的退款方法 (- payment - varchar)(来自 ps_orders)并将其与 - name -(来自 payment_method)的方法进行比较，然后检索关联的退款方法ID。我在仍然空白的列(订单退款的 id_ payment_method )中返回这个列，它绝对等待一个整数。

我别无选择，只能这样做，我已经测试过基于 INSERT INTO 和 JOIN 的查询，但我有点迷失。有人知道这句话是什么吗？

提前谢谢您!

Answer 1

插入用于根据您的解释插入新行

似乎您正在根据订单中的值寻找更新

  update order_refund 
  INNER JOIN ps_orders ON order_refund.id_order = ps_orders.id_order
  INNER JOIN payment_method ON payment_method.name  = ps_orders.payment
      set order_refund.id_payment_method = payment_method.id_payment_method