select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where status<>'C' group by pop,prot,sw_or_local And I have this result :
+--------+--------+-------------+--------+
| pop | prot | sw_or_local | sum |
+--------+--------+-------------+--------+
| BHE | R2 | local 50
| | BHE | R2 | local 12
| +--------+--------+-------------+--------+
It looks to me like a data problem, where some rows have leading tabs or spaces before "R2" in the prot column and others don't.
Bruce Feist
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
