SELECT ntnotcnot, ntnotfein, ntnotante, ntnottitu, ntnotturl, ntnottext, ntnotcsec, ntsecimpo, ntnotimpo, ntsecnomb, ntsecnpag, ntfovenla, ntfovdpie, ntautenla, ntautnomb, ntautapat FROM ntnot LEFT JOIN ntaut ON ntnotcaut=ntautcaut INNER JOIN ntsec ON ntseccsec=ntnotcsec LEFT JOIN ntfov ON ntnotcnot=ntfovcnot AND ntfovimpo=1 AND ntnotfein=ntfovfein AND ntfovesta=1 AND ntfovtipo!='E' WHERE ntnotfein='2017-06-14' AND ntnotcsec=3 AND ntnotesta=1 AND ntnotulth!=1 ORDER BY ntnotimpo DESC;SENTIMOS LAS MOLESTIAS EN BREVE SOLUCIONAREMOS EL PROBLEMA.