Ok ya lo corregi quedo asi:
Código sql:
Ver originalSELECT FACTURA, MOVIL,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil),
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'BAM' AND) AS BAM,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'MMS' AND) AS MMS,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'RPV' AND) AS RPV,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'SME' AND) AS SME,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'SMR' AND) AS SMR,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'TEL' AND) AS TEL,
(SELECT SUM(valor + sobrecargo)
FROM trafico
WHERE factura = a.factura AND movil = a.movil AND SERVICIO = 'TLL' AND) AS TLL
FROM TRAFICO a
WHERE (FACTURA = '16209216')
GROUP BY FACTURA, MOVIL
Pero me indica otro error dice:
Linea 1 :sintaxis incorrecta cerca de ')'
Y disculpa todas las preguntas GeoAvila sinceramente agradesco tu interes
