在SQL Update中使用Distinct

根据您的评论，

all of the matching rows should be updated

UPDATE SETTING_VALUESET Enabled = 0FROM SETTING_VALUE vINNER JOIN SETTING s ON v.SettingID = s.SettingIDINNER JOIN LU_FIELD f ON f.FieldID = s.FieldIDWHERe v.DisplayValue LIKE '%Miami%'AND f.ControlName LIKE '%City%'

您选择的所有内容都会更新。