i have this kind of query
(select count(*) as ctr, datecreated from webblogs where userid='9' group by month(datecreated), year(datecreated))
union all
(select count(*) as ctr, datecreated from txtblogs where userid='9' group by month(datecreated), year(datecreated))
order by datecreated desc
it actually query the data properly but from my query it qould still seperated the data of webblogs and txtblogs
so if you going to look on the result there is like 2 for the month of november and december
so my question is that can i still group it again?
so it gave me an error if i use like this
(select count(*) as ctr, datecreated from webblogs where userid='9' group by month(datecreated), year(datecreated))
union all
(select count(*) as ctr, datecreated from txtblogs where userid='9' group by month(datecreated), year(datecreated))
group by month(datecreated), year(datecreated)
order by datecreated desc
thank you in advance for those willing to help.