mysql - 使用连接合并两个 mySQL 查询

Question

我知道我需要为此做一些子查询，但我无法让它工作。

查询 1:

SELECT full_db3.dma, dma_list.dma_name 
from `full_db3` 
inner join dma_list on full_db3.dma = dma_list.dma;

查询 2:

SELECT dma, COUNT(*) as dma_count, 
    round(COUNT(*)/(SELECT COUNT(*) FROM full_db3) * 100,2) as dma_percent 
FROM full_db3 
where dma != '0' 
GROUP BY dma 
ORDER BY dma_count DESC;

第一个查询将 dma 编号与 dma 名称进行匹配。我需要的是将此 dma 名称添加到作为查询 2 的结果从查询返回的内容中，以便给我:dma, dma_name, dma_percent

结合这些的最佳方式是什么？

Answer 1

只需将 JOIN 与 dma_list 添加到第二个查询:

SELECT full_db3.dma, dma_list.dma_name, COUNT(*) as dma_count, 
    round(COUNT(*)/(SELECT COUNT(*) FROM full_db3) * 100,2) as dma_percent 
FROM full_db3 
INNER JOIN dma_list on full_db3.dma = dma_list.dma
where full_db3.dma != '0' 
GROUP BY full_db3.dma 
ORDER BY dma_count DESC;