php - 如何加入两个大查询？

Question

这是我的第一个查询..

SELECT cmp.bundles_id, 
MONTH(cmp.payment_date) as month, 
sum(vb.bundle_price) as bundle_Price 
FROM `voice_bundles` as cmp 
join `voice_bundles_price` as vb 
ON cmp.bundles_id=vb.id 
GROUP BY MONTH(cmp.payment_date)

这是我的第二个查询..

SELECT 
MONTH(bill_due_date) as month, 
sum(charges) as Intercom,
sum(package_rent) as packages_price 
from `bill` 
GROUP BY MONTH(bill_due_date)

我想根据月份在同一个表中显示数据...但问题是字段名称是 MONTH(bill_due_date) as month 和 MONTH(cmp.payment_date ) 作为月份

两个查询的月份相同..

我如何将两个查询结合起来并使其成为一个......并想要这样的输出？

Answer 1

你可以试试表之间的连接

select a.month, a.bundle_Price,  b.Intercom, b.packages_price
from (
  SELECT cmp.bundles_id, 
  MONTH(cmp.payment_date) as month, 
  sum(vb.bundle_price) as bundle_Price 
  FROM `voice_bundles` as cmp 
  join `voice_bundles_price` as vb 
  ON cmp.bundles_id=vb.id 
  GROUP BY MONTH(cmp.payment_date) 7
) a
inner join (
  SELECT 
  MONTH(bill_due_date) as month, 
  sum(charges) as Intercom,
  sum(package_rent) as packages_price 
  from `bill` 
  GROUP BY MONTH(bill_due_date)
) b
on a.month = b.month