mysql - 如何连接两个mysql状态不同的表

Question

现在我得到了两个查询的结果，但我想加入两个结果

第一个查询

select count(*) from ih;

这是结果

count(*)
'200000'

第二个查询

select
GROUP_CONCAT(if(rating='01', cnt, NULL)) AS 'A',  
GROUP_CONCAT(if(rating='02', cnt, NULL)) AS 'B',
GROUP_CONCAT(if(rating='03', cnt, NULL)) AS 'C',
GROUP_CONCAT(if(rating='04', cnt, NULL)) AS 'D',
GROUP_CONCAT(if(rating='05', cnt, NULL)) AS 'E'
from
(
select rating, count(1) cnt from de.rec ri group by 
(rating)
) a;

这是结果

  A, B, C, D, E
'1222', '2851', '4638', '4325', '29206'

但是我想要得到这样的结果

count(*), A, B, C, D, E
'200000', '1222', '2851', '4638', '4325', '29206'

所以如果有人知道这个方法请教我

Answer 1

您可以将您的选择并排放置

select
(select count(*) from ih),
GROUP_CONCAT(if(rating='01', cnt, NULL)) AS 'A',  
GROUP_CONCAT(if(rating='02', cnt, NULL)) AS 'B',
GROUP_CONCAT(if(rating='03', cnt, NULL)) AS 'C',
GROUP_CONCAT(if(rating='04', cnt, NULL)) AS 'D',
GROUP_CONCAT(if(rating='05', cnt, NULL)) AS 'E'
from
(
select rating, count(1) cnt from de.rec ri group by 
(rating)
) a;