I found answer

来源: peterqpang 于 2004-09-03 08:20:11 [] [旧帖] [给我悄悄话] 阅读数 : (201 bytes)

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]

请您先登陆，再发跟帖！