Ver originalSELECT * FROM tabla1 t1 LEFT JOIN tabla2 t2 ON t1.id = t2.factura_id LEFT JOIN tabla3 t3 ON t1.id=t3.factura_id WHERE t2.factura_id IS NOT NULL AND t3.factura_id IS NULL