sql query UPDATE t1 FROM t1 JOIN (SELECT)

Question

我有

You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near 'FROM cards t1

t1
SET
t1.driver = t2.mv,
t1.number = t2.pt
FROM 
cards t1
LEFT JOIN 
(SELECT meta_value mv, post_title pt
FROM wpwx_posts 
LEFT OUTER JOIN wpwx_postmeta AS PM
ON post_id = ID
AND meta_key = 'cardholder'
WHERE post_type='bilet') t2
ON t1.number = t2.pt  

((中的代码是正确的，可以使用

FROM cards AS t1
LEFT JOIN (SELECT PM.meta_value AS mv, P.post_title AS pt
FROM wpwx_posts AS P 
LEFT OUTER JOIN wpwx_postmeta AS PM
ON PM.post_id = ID
AND PM.meta_key = 'cardholder'
WHERE P.post_type='bilet') AS t2
ON t1.number = t2.pt

Answer 1

您似乎正在尝试更新表，在SET之后使用FROM将是无效的语法。公布整个查询会很有帮助。