SELECT distinct(cuenta), vencida ,enCurso as val, IFNULL(tbl_linea_credito.razon_social, 'S/I') as cliente
FROM tbl_resumen_informe_gestion LEFT JOIN tbl_linea_credito
ON tbl_resumen_informe_gestion.cuenta = tbl_linea_credito.deudor
WHERE (vencida <> 0 or enCurso<>0) AND mes=9 AND año=2018
and clave=1207 and ejecutivo='Milva Ortiz' AND (area='C101' or area='C103') order by cuenta