如何加入两个大查询？

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) as month

月将是两者相同的查询..

如何使COMBI ñ两个查询，并使其成为一个..并希望像这样的输出？

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