sqlserver update select
update a set a.userDataId = b.id
from HealthReportUserData a
left join HealthReportUserInfo b on a.email=b.email
where b.email ='xxxxxx;
update a set a.userDataId = b.id
from HealthReportUserData a
left join HealthReportUserInfo b on a.email=b.email
where b.email ='xxxxxx;