I would like to make a query that give me the following
result:
2 tables:
call
phone_number,dest_number,durantion
extention
phone_number,employee
I would like to have the following result:
phone_number, employee, total call made
I'm running the following query
select
call.phone_number,extention.employee,count(call.Phone_number)
from call left join extention on
extention.phone_number=call.phone_number
goup by call.phone_number.
This query is taking for ever if I got 200.000 records in
call. It look like it's doing the join on the call table and the grouping.
Is there a way to have the geoupping done that return me 200 row and the the
join.
Thanks in advance for your help
Philippe
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
