Hi, I could use some advice on this query.
SELECT cell, sum(att) as att , sum(lc) as lc , sum(csh) as csh, ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc + suf)),2) AS drops, sum(tccf) as tccf, sum(bpp) as bpp, sum(bpc) as bpc, sum(suf) as suf, ROUND((SUM( tccf + bpp + bpc + suf) *100 ),2) / ROUND(SUM(att),2) AS blocks, sum(mou) as mou, release FROM ss WHERE release=CURDATE() AND (( cell=2 and sector=1) OR (cell=3 and sector=1)) GROUP BY cell ORDER BY hour; It works fine. But I cannot figure out how to add the results together where cell2 and cell3 are tallied together on one line. Any help with changing the query would be appreciated. Thanks as ever! Regards, Kelly Black Linux was very clearly the answer, but what was the question again? --------------------------------------------------------------------- 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
