I have the below query which shows totals for the month. Question is how do I show the month in a fourth column with the actual month. (Saying like "January" for example). Any help would be greatly appreciated.
SELECT COUNT(studyTbl.studyid_i) as study_count, companyTbl.companyname_vc
FROM physicianTbl INNER JOIN
companyTbl ON physicianTbl.companyid_i = companyTbl.companyid_i INNER JOIN
studyTbl ON physicianTbl.physicianid_i = studyTbl.primarycarephysicianid_i
GROUP BY Month(studydt_dt) , companyTbl.companyname_vc