select cho.cho_id from tbl_CHO_Operators cho inner join tbl_CHO_Segment_NHS nhs on cho.cho_id = nhs.cho_id and cho.cho_segmentId = 5 where nhs.providerId = and nhs.providerId is not null UPDATE tbl_CHO_Operators SET cho_phoneac = , cho_phone = WHERE cho_id =