Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- idOT........FIELD_1.....FIELD_2......CampodeOtraTabla.
- SELECT idOT, SUM(`FIELD_1`),SUM(`FIELD_2`)
- FROM (
- (SELECT idOT, SUM(`horaspreparacion`.`Horas`) AS `FIELD_1` ,
- SUM(`horaspreparacion`.`HorasX`) AS `FIELD_2`
- FROM `horaspreparacion`)
- UNION
- (SELECT idOT, SUM(`horasimprimacion`.`Horas`) AS `FIELD_1`,
- SUM(`horasimprimacion`.`HorasX`) AS `FIELD_2`
- FROM `horasimprimacion`)
- UNION
- (SELECT idOT, SUM(`horasintermedia`.`Horas`) AS `FIELD_1`,
- SUM(`horasintermedia`.`HorasX`) AS `FIELD_2`
- FROM `horasintermedia` )
- UNION
- (SELECT idOT, SUM(`horasacabado`.`Horas`) AS `FIELD_1`,
- SUM(`horasacabado`.`HorasX`) AS `FIELD_2`
- FROM `horasacabado`)
- UNION
- (SELECT idOT,SUM(`horascdot`.`Horas`) AS `FIELD_1`,
- SUM(`horascdot`.`HorasX`) AS `FIELD_2`
- FROM `horascdot` )
- UNION
- (SELECT idOT,SUM(`horasotros`.`Horas`) AS `FIELD_1`,
- SUM(`horasotros`.`HorasX`) AS `FIELD_2`
- FROM `horasotros` )
- ) AS prueba
- SELECT prueba.idOT,
- SUM(prueba.FIELD_1),
- SUM(prueba.FIELD_2),
- OT.CampodeOtraTabla
- FROM (
- ...
- ) AS prueba
- LEFT JOIN OtraTabla OT
- ON OT.idOT = prueba.idOT
Add Comment
Please, Sign In to add comment