I am using MySql to store telephone taxes statistics. I have 1 table by month with 60'000 rows each.
My problem is that I need some stats for 3 month. For example I need to know the total Time(in second) and total Cost for each Number on a 3 month basis. Is it possible to do it without creating new tables, and with only one query? The expectec result would be: Number Total Time Total Cost 501 169 0.80 502 61 0.30 CREATE TABLE may (Number VARCHAR(10), Time INTEGER, Cost DECIMAL(5,2)); CREATE TABLE june (Number VARCHAR(10), Time INTEGER, Cost DECIMAL(5,2)); insert may values ("501", 31, 0.10); insert may values ("502", 51, 0.20); insert may values ("501", 93, 0.40); insert may values ("501", 25, 0.10); insert june values ("501", 10, 0.10); insert june values ("502", 10, 0.10); insert june values ("501", 10, 0.10); Regards Denis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]