SQL Update

sql：

Update a
SET a.province=b.khprovince,
    a.city =b.khcity,
	a.county = b.khcouty,
	a.town = b.rkhcouty
from 客户校对 as a ,dbo.行政区划 as b
where 
khmc like '%'+b.khprovince+'%'