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