Page History

SELECT e.entity_id, e.name, ei.erdc_instance_id, ei.name, ei.is_host_check
         FROM entity e, erdc_configuration ec, erdc_instance ei
         WHERE ei.configuration_id = ec.id and e.entity_id = ei.entity_id and e.entity_id IN
               (select e.entity_id from entity e left join erdc_instance ei on e.entity_id = ei.entity_id and ei.is_host_check = 1 where ei.is_host_check is null)