update Technique_HazardList
set HazardLevel = b.RiskLevelId
from  Technique_HazardList a left join Base_RiskLevel b 
on( a.HazardJudge_D<b.MaxValue or b.MaxValue is null) and (a.HazardJudge_D>=b.MinValue or b.MinValue is null)