I found answer

来源: 于 2004-09-03 08:20:11 [旧帖] [给我悄悄话] 本文已被阅读：次

update tbl_surveys
set site_specific_3=en.site_specific_3
from tbl_surveys left join youthmapentry.dbo.tbl_surveys en
on tbl_surveys.site_number=en.site_number
and tbl_surveys.[id]=en.[id]