select cho.cho_id from tbl_CHO_Operators cho inner join tbl_CHO_Segment_PSS pss on cho.cho_id = pss.cho_id where cho_segmentId = 2 and pss.nces_districtId = update tbl_CHO_Segment_PSS set state_districtId = where cho_id =