Alex, I actually did this with PHP... Not 100% sure if it is possible with just a SQL statement.

What I did was I selected the count from the table I wanted and then saved that to a variable, then I added that to the corresponding row in another table. So I used 2 SQL statements to do it really, just used PHP to hold the variable.