The fourth column would me titled 'soma'
There is no seperator bar between the data for sw_or_local and soma on the data lines.
Fabio Bernardo wrote:
hi there I wrote this querie : 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
| +--------+--------+-------------+--------+
.
.
.
.
.
Have you see,? I would like something like that:
| pop | prot | sw_or_local | sum |
+--------+--------+-------------+--------+
| BHE | R2 | local 62
Is my group by querie wrong...?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
