> mysql> SELECT cell, sector, If you only want one row, then selecting cell doesn't make any sense. Cell is different in each row you've selected. If you only want one row, don't 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 / SUM(att),2) > AS blocks, > -> sum(mou) as mou > -> FROM ss > -> WHERE release=CURDATE() > -> GROUP BY cell "Group by cell" means "Give me a total for each cell". If you only want one row, you don't need a group by at all; if you want one row per sector, you should group by sector. > -> HAVING sector=1 AND (cell=148 or cell=3); This doesn't belong in the Having clause. This needlessly slows you query down. This can go in the where clause. See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT. --------------------------------------------------------------------- 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
