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]