API tools faq
paste
Guest User

Untitled

a guest
Oct 19th, 2017
79
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.89 KB | None | 0 0
raw download clone embed print report
  1. SELECT DISTINCT(E.numempleado) AS Numero, E.apellido+" "+E.nombre AS Nombre,
  2.  
  3. (SELECT L.alias
  4. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  5. WHERE PPL1.numemple=PPL.numemple
  6. AND PPL1.id_status=L.id
  7. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  8. AND PPL1.NumDia=1) AS Dia1,
  9.  
  10. (SELECT L.alias
  11. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  12. WHERE PPL1.numemple=PPL.numemple
  13. AND PPL1.id_status=L.id
  14. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  15. AND PPL1.NumDia=2) AS Dia2,
  16.  
  17. (SELECT L.alias
  18. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  19. WHERE PPL1.numemple=PPL.numemple
  20. AND PPL1.id_status=L.id
  21. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  22. AND PPL1.NumDia=3) AS Dia3,
  23.  
  24. (SELECT L.alias
  25. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  26. WHERE PPL1.numemple=PPL.numemple
  27. AND PPL1.id_status=L.id
  28. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  29. AND PPL1.NumDia=4) AS Dia4,
  30.  
  31. (SELECT L.alias
  32. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  33. WHERE PPL1.numemple=PPL.numemple
  34. AND PPL1.id_status=L.id
  35. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  36. AND PPL1.NumDia=5) AS Dia5,
  37.  
  38. (SELECT L.alias
  39. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  40. WHERE PPL1.numemple=PPL.numemple
  41. AND PPL1.id_status=L.id
  42. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  43. AND PPL1.NumDia=6) AS Dia6,
  44.  
  45. (SELECT L.alias
  46. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  47. WHERE PPL1.numemple=PPL.numemple
  48. AND PPL1.id_status=L.id
  49. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  50. AND PPL1.NumDia=7) AS Dia7,
  51.  
  52. (SELECT L.alias
  53. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  54. WHERE PPL1.numemple=PPL.numemple
  55. AND PPL1.id_status=L.id
  56. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  57. AND PPL1.NumDia=8) AS Dia8,
  58.  
  59. (SELECT L.alias
  60. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  61. WHERE PPL1.numemple=PPL.numemple
  62. AND PPL1.id_status=L.id
  63. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  64. AND PPL1.NumDia=9) AS Dia9,
  65.  
  66. (SELECT L.alias
  67. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  68. WHERE PPL1.numemple=PPL.numemple
  69. AND PPL1.id_status=L.id
  70. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  71. AND PPL1.NumDia=10) AS Dia10,
  72.  
  73. (SELECT L.alias
  74. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  75. WHERE PPL1.numemple=PPL.numemple
  76. AND PPL1.id_status=L.id
  77. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  78. AND PPL1.NumDia=11) AS Dia11,
  79.  
  80. (SELECT L.alias
  81. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  82. WHERE PPL1.numemple=PPL.numemple
  83. AND PPL1.id_status=L.id
  84. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  85. AND PPL1.NumDia=12) AS Dia12,
  86.  
  87. (SELECT L.alias
  88. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  89. WHERE PPL1.numemple=PPL.numemple
  90. AND PPL1.id_status=L.id
  91. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  92. AND PPL1.NumDia=13) AS Dia13,
  93.  
  94. (SELECT L.alias
  95. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  96. WHERE PPL1.numemple=PPL.numemple
  97. AND PPL1.id_status=L.id
  98. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  99. AND PPL1.NumDia=14) AS Dia14,
  100.  
  101. (SELECT L.alias
  102. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  103. WHERE PPL1.numemple=PPL.numemple
  104. AND PPL1.id_status=L.id
  105. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  106. AND PPL1.NumDia=15) AS Dia15,
  107.  
  108. (SELECT L.alias
  109. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  110. WHERE PPL1.numemple=PPL.numemple
  111. AND PPL1.id_status=L.id
  112. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  113. AND PPL1.NumDia=16) AS Dia16,
  114.  
  115. (SELECT L.alias
  116. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  117. WHERE PPL1.numemple=PPL.numemple
  118. AND PPL1.id_status=L.id
  119. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  120. AND PPL1.NumDia=17) AS Dia17,
  121.  
  122. (SELECT L.alias
  123. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  124. WHERE PPL1.numemple=PPL.numemple
  125. AND PPL1.id_status=L.id
  126. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  127. AND PPL1.NumDia=18) AS Dia18,
  128.  
  129. (SELECT L.alias
  130. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  131. WHERE PPL1.numemple=PPL.numemple
  132. AND PPL1.id_status=L.id
  133. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  134. AND PPL1.NumDia=19) AS Dia19,
  135.  
  136. (SELECT L.alias
  137. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  138. WHERE PPL1.numemple=PPL.numemple
  139. AND PPL1.id_status=L.id
  140. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  141. AND PPL1.NumDia=20) AS Dia20,
  142.  
  143. (SELECT L.alias
  144. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  145. WHERE PPL1.numemple=PPL.numemple
  146. AND PPL1.id_status=L.id
  147. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  148. AND PPL1.NumDia=21) AS Dia21,
  149.  
  150. (SELECT L.alias
  151. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  152. WHERE PPL1.numemple=PPL.numemple
  153. AND PPL1.id_status=L.id
  154. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  155. AND PPL1.NumDia=22) AS Dia22,
  156.  
  157. (SELECT L.alias
  158. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  159. WHERE PPL1.numemple=PPL.numemple
  160. AND PPL1.id_status=L.id
  161. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  162. AND PPL1.NumDia=23) AS Dia23,
  163.  
  164. (SELECT L.alias
  165. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  166. WHERE PPL1.numemple=PPL.numemple
  167. AND PPL1.id_status=L.id
  168. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  169. AND PPL1.NumDia=24) AS Dia24,
  170.  
  171. (SELECT L.alias
  172. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  173. WHERE PPL1.numemple=PPL.numemple
  174. AND PPL1.id_status=L.id
  175. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  176. AND PPL1.NumDia=25) AS Dia25,
  177.  
  178. (SELECT L.alias
  179. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  180. WHERE PPL1.numemple=PPL.numemple
  181. AND PPL1.id_status=L.id
  182. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  183. AND PPL1.NumDia=26) AS Dia26,
  184.  
  185. (SELECT L.alias
  186. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  187. WHERE PPL1.numemple=PPL.numemple
  188. AND PPL1.id_status=L.id
  189. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  190. AND PPL1.NumDia=27) AS Dia27,
  191.  
  192. (SELECT L.alias
  193. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  194. WHERE PPL1.numemple=PPL.numemple
  195. AND PPL1.id_status=L.id
  196. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  197. AND PPL1.NumDia=28) AS Dia28,
  198.  
  199. (SELECT L.alias
  200. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  201. WHERE PPL1.numemple=PPL.numemple
  202. AND PPL1.id_status=L.id
  203. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  204. AND PPL1.NumDia=29) AS Dia29,
  205.  
  206. (SELECT L.alias
  207. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  208. WHERE PPL1.numemple=PPL.numemple
  209. AND PPL1.id_status=L.id
  210. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  211. AND PPL1.NumDia=30) AS Dia30,
  212.  
  213. (SELECT L.alias
  214. FROM reportes RP, PPL_leyenda L INNER JOIN pago_prima_legal PPL1 ON L.id=PPL1.id_status
  215. WHERE PPL1.numemple=PPL.numemple
  216. AND PPL1.id_status=L.id
  217. AND PPL1.fechaElab BETWEEN RP.fechaDEL AND RP.fechaAL
  218. AND PPL1.NumDia=31) AS Dia31
  219.  
  220. FROM empleados AS E LEFT JOIN pago_prima_legal AS PPL ON E.numempleado = PPL.numemple;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!