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;

posted @ 2020-04-08 19:39  林鹿鸣  阅读(3421)  评论(0)    收藏  举报
canvas#live2dcanvas { border: 0 !important; right: 0; //修改动画在左右的位置 }