这是我的第一个查询。
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
两个查询的月份相同。
我如何使两个查询结合起来并使其成为一个..并想要这样的输出?
您可以尝试在表之间进行联接
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
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句