use DB_2271_main; insert into nf_alert_region_entity ( alert_region_id, alert_entity_id, region_id, ncr_number ) select b.alert_region_id, a.entity_id as alert_entity_id , a.region_id, c.ncr_number from regions_entities a, nf_alert_region b, entities c where b.region_id=a.region_id and c.entity_id=a.entity_id update nf_alert_region_entity set entity_name= (select nf_alert_entity.entity_name from nf_alert_entity where nf_alert_entity.alert_entity_id=nf_alert_region_entity.alert_entity_id)