2 lines
448 B
SQL
2 lines
448 B
SQL
select a.HazardJudge_D,a.HazardLevel,b.RiskLevelName 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)
|
|
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) |