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]
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]