MySQL - getting SUM of MAX results from 2 tables
- by SODA
Hi,
Here's my problem:
I have 2 identical tables (past month data, current month data) - data_2010_03, data_2010_04:
Content_type (VARCHAR), content_id (INT), month_count (INT), pubDate (DATETIME)
Data in month_count is updated hourly, so for each combination of content_type and content_id we insert new row, where value of month_count is…