Re: Querying 2 counts

[John Noble]

Think I got it working now.

select CONCAT(year(invoiceDate), " ", MONTHNAME(STR_TO_DATE(month(invoiceDate), '%m'))) as yrmnth,
sum(case when docType = 'Inv' and countryID = p_countryID and invoiceDate BETWEEN p_fromDate and p_toDate then 1 else 0 end) invCount,
sum(case when docType = 'Crd' and countryID = p_countryID and invoiceDate BETWEEN p_fromDate and p_toDate then 1 else 0 end) CreditCount
from salesLedger WHERE invoiceDate BETWEEN p_fromDate and p_toDate
group by year(invoiceDate), month(invoiceDate);