5 lines
227 B
MySQL
5 lines
227 B
MySQL
|
|
||
|
|
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)
|