将一个查询作为另一个查询结果的过滤器 MySQL

Question

我有两个查询如下，

A SELECT DISTINCT meta_value, meta_id FROM `wp_postmeta` WHERE `meta_key`='destination';
B SELECT ID FROM wp_posts WHERE post_status = 'publish';

我想要的是这样的东西，

SELECT meta_value FROM A WHERE A.meta_id = B.ID;

Answer 1

try this

SELECT  A.meta_value, A.meta_id 
FROM `wp_postmeta` A
INNER JOIN wp_posts  B
ON meta_id = id
WHERE A.`meta_key`= 'destination'
AND B.post_status = 'publish' 
GROUP BY   A.meta_value

Answer 2

SELECT DISTINCT
  meta_value
FROM `wp_postmeta` wpm,
  wp_posts wp
WHERE wp.ID = wpm.meta_id
    AND wpm.`meta_key` = 'destination'
    AND wp.post_status = 'publish';