Advertisement
nhorquender

Untitled

Dec 6th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. SELECT v1.totalGarancia, v2.estado FROM (select SUM(importe_moneda) as totalGarancia from tbl_garantias_clientes WHERE cuenta = "744569") as v1,
  2. (select distinct(
  3. IF(STR_TO_DATE(vencimiento, '%d-%m-%Y') > NOW(), "VENCIDA",
  4. IF(DATE_ADD(STR_TO_DATE(vencimiento, '%d-%m-%Y'), INTERVAL 2 MONTH) > NOW(), "POR VENCER", "VIGENTE"))) as estado
  5. from tbl_garantias_clientes WHERE cuenta = "744569") as v2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement