how to simplyfied this subquery

[osusano]

select datecreated, count(*) from 
(select datecreated from webblogs where userid='9'
union all 
select datecreated from txtblogs where userid='9')
group by group by month(datecreated), year(datecreated)
order by datecreated desc

is there's a chance i could simplified this query or how can i make this work on mysql ver. 4.0

i not sure if the subquery for for version 4.0 coz it always gives me an error

[Roger_Ramjet]

Nope, you can't do subqueries in 4.0, has to be 4.1 or above. From the manual

"With MySQL versions prior to 4.1, it was necessary to work around or avoid the use of subqueries. In many cases, subqueries can successfully be rewritten using joins and other methods. See section 13.1.8.11 Rewriting Subqueries as Joins for Earlier MySQL Versions."

sybquery rewrite