UNION
Publicado por SARA (21 intervenciones) el 28/02/2020 15:45:10
COMO PUEDO SEPARAR CADA CONSULTA EN DIFERENTES COLUMNAS?
select SUM( importe ) AS dia FROM detpercepcion WHERE percepcion = 'Dia Festivo' GROUP BY noempleado
UNION ALL
select SUM( importe ) AS bono FROM detpercepcion WHERE percepcion = 'Bono de Produccion' GROUP BY noempleado
select SUM( importe ) AS dia FROM detpercepcion WHERE percepcion = 'Dia Festivo' GROUP BY noempleado
UNION ALL
select SUM( importe ) AS bono FROM detpercepcion WHERE percepcion = 'Bono de Produccion' GROUP BY noempleado
Valora esta pregunta


0