Guest User

Untitled

a guest
Dec 11th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. idOT........FIELD_1.....FIELD_2......CampodeOtraTabla.
  2.  
  3. SELECT idOT, SUM(`FIELD_1`),SUM(`FIELD_2`)
  4. FROM (
  5. (SELECT idOT, SUM(`horaspreparacion`.`Horas`) AS `FIELD_1` ,
  6. SUM(`horaspreparacion`.`HorasX`) AS `FIELD_2`
  7. FROM `horaspreparacion`)
  8. UNION
  9. (SELECT idOT, SUM(`horasimprimacion`.`Horas`) AS `FIELD_1`,
  10. SUM(`horasimprimacion`.`HorasX`) AS `FIELD_2`
  11. FROM `horasimprimacion`)
  12. UNION
  13. (SELECT idOT, SUM(`horasintermedia`.`Horas`) AS `FIELD_1`,
  14. SUM(`horasintermedia`.`HorasX`) AS `FIELD_2`
  15. FROM `horasintermedia` )
  16. UNION
  17. (SELECT idOT, SUM(`horasacabado`.`Horas`) AS `FIELD_1`,
  18. SUM(`horasacabado`.`HorasX`) AS `FIELD_2`
  19. FROM `horasacabado`)
  20. UNION
  21. (SELECT idOT,SUM(`horascdot`.`Horas`) AS `FIELD_1`,
  22. SUM(`horascdot`.`HorasX`) AS `FIELD_2`
  23. FROM `horascdot` )
  24. UNION
  25. (SELECT idOT,SUM(`horasotros`.`Horas`) AS `FIELD_1`,
  26. SUM(`horasotros`.`HorasX`) AS `FIELD_2`
  27. FROM `horasotros` )
  28. ) AS prueba
  29.  
  30. SELECT prueba.idOT,
  31. SUM(prueba.FIELD_1),
  32. SUM(prueba.FIELD_2),
  33. OT.CampodeOtraTabla
  34. FROM (
  35. ...
  36. ) AS prueba
  37. LEFT JOIN OtraTabla OT
  38. ON OT.idOT = prueba.idOT
Add Comment
Please, Sign In to add comment