字压表中的删除

Question

我有这些wordpress表：

jlc_posts和jlc_postmeta

我做了一个这样的查询：

SELECT po.post_title,alm.meta_key,alm.meta_value,pmstock.meta_key,pmstock.meta_value
FROM jlc_posts po LEFT JOIN jlc_postmeta alm ON po.id = alm.post_id LEFT JOIN jlc_postmeta pmstock ON po.id = pmstock.post_id where alm.meta_key='almacen' and (alm.meta_value=1 or alm.meta_value=2) AND (pmstock.meta_key='_stock' and pmstock.meta_value=0)

它运行良好，但如何将此查询转换为DELETE查询？我找不到答案。

Answer 1

DELETE FROM tableName WHERE keyID = (SELECT po.post_title,alm.meta_key,alm.meta_value,pmstock.meta_key,pmstock.meta_value
FROM jlc_posts po LEFT JOIN jlc_postmeta alm ON po.id = alm.post_id LEFT JOIN jlc_postmeta pmstock ON po.id = pmstock.post_id where alm.meta_key='almacen' and (alm.meta_value=1 or alm.meta_value=2) AND (pmstock.meta_key='_stock' and pmstock.meta_value=0));