mysql update 从关联表中 取值

UPDATE t_fi_invoice_ocr o
INNER JOIN (
  SELECT
    id,
    approve_date,
    is_deleted
  FROM
    t_fi_invoice
) i
SET o.approved_date = i.approve_date
WHERE
        o.is_deleted=0
 AND i.is_deleted=0
 AND o.invoice_id = i.id
 AND o.`status`=18