Query on multiple table with SUM and GROUP

2004-08-02 Thread Denis Geser
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

Re: Query on multiple table with SUM and GROUP

2004-08-02 Thread Egor Egorov
Denis Geser [EMAIL PROTECTED] wrote: 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.

Re: Query on multiple table with SUM and GROUP

2004-08-02 Thread Whil Hentzen
On Monday 02 August 2004 02:39, Denis Geser wrote: 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

Re: Query on multiple table with SUM and GROUP

2004-08-02 Thread Denis Geser
On Monday 02 August 2004 02:39, Denis Geser wrote: 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