How to Join two big Queries?
<p>Here is my first query..</p>

<pre><code>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)
</code></pre>

<p>Here is my 2nd query..</p>

<pre><code>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)
</code></pre>

<p>I want to show the data in the same table according to the month... but the problem is field name which is <code>MONTH(bill_due_date) as month</code> and <code>MONTH(cmp.payment_date) as month</code></p>

<p>Months will be Same for both queries..</p>

<p>How do i make combine both queries and make it one.. and want the output like this?</p>

<p><a href="https://i.stack.imgur.com/552jO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/552jO.png" alt="enter image description here"></a></p>