Error with query adding fields from different tables in MySql

Question

Error with query adding fields from different tables in MySql

Navigation

#1 by (1 votes)

-2

What I'm looking for is for me to add up the total amount of each field and show it to me but what it shows is a text, I do not understand why this happens

CODE:

SELECT totales_bonos.idEmpleado, 'bonos.pmonto'  Bonos,
                                 'anticipos.primerMonto'  Anticipos,
                                 'deducciones.primerMonto'  Deducciones
FROM
    (SELECT idEmpleado,
           SUM(b.pmonto)  'bonos.pmonto'
    FROM bonos b
    GROUP BY idEmpleado) as totales_bonos

    INNER JOIN

    (SELECT idEmpleado,
           SUM(a.primerMonto) 'anticipos.primerMonto'
    FROM anticipos a
    GROUP BY idEmpleado) as totales_anticipos

    on (totales_bonos.idEmpleado = totales_anticipos.idEmpleado)

    INNER JOIN

    (SELECT idEmpleado,
           SUM(d.primerMonto) 'deducciones.primerMonto'
    FROM deducciones d
    GROUP BY idEmpleado) as totales_deducciones

    on (totales_bonos.idEmpleado = totales_deducciones.idEmpleado)

ORDER BY totales_bonos.idEmpleado

THIS IS WHAT I GET:

mysql query

asked by Stivin Martinez Sosa 24.04.2018 в 09:16

source

1 answer

Problem with Codeigniter Error: Type: ArgumentCountError How to check if a div has no content

score 1 · Accepted Answer

You are making huge mistakes in that query, to make it I recommend you use nested queries like this:

SELECT T.idEmpleado,
    (SELECT SUM(b.pmonto)  
    FROM bonos b
    where b.idEmpleado=T.idEmpleado) as Bonos,
    (SELECT SUM(a.primerMonto)
    FROM anticipos a
    where a.idEmpleado=T.idEmpleado) as Anticipos,
    (SELECT SUM(d.primerMonto) 
    FROM deducciones d
    where d.idEmpleado=T.idEmpleado) as Deducciones
FROM totales_bonos T
ORDER BY T.idEmpleado

I hope you find it helpful, greetings.