rechazo RA 7 días

SELECT * FROM hist_DTE t1
LEFT JOIN(SELECT MIN(id_aceptacion) AS id,id_DTE FROM aceptaciones_IN WHERE estado='2' GROUP BY id_DTE)t2 ON t1.id_DTE=t2.id_DTE
INNER JOIN comprob_aceptacion_IN t3 ON t2.id=t3.id_comp_acep
WHERE t1.borrado='NO' AND t1.fecha_emision >='2000-01-01'