update AKUZ.T_ONK_TREATMENT_CASE otc
set OutcomeOfInspection = me.OutcomeRecord
from akuz.T_MEDICAL_EPISODE me
left join AKUZ.T_ONK_TREATMENT_CASE otcOld on otcOld.OutcomeOfInspection = me.OutcomeRecord
where otc.OutcomeOfInspection is null and me.OutcomeRecord is not null and otcOld.OnkTreatmentCaseID is null;