多表更新数据:
例:
update A set A.username=B.username, A.tel=B.tel , A.email=B.email , A.role=B.sex
from GaiaSaver_BUG A,GaiaSaver_Apply B
where A.userid=B.userid
多表更新数据:
例:
update A set A.username=B.username, A.tel=B.tel , A.email=B.email , A.role=B.sex
from GaiaSaver_BUG A,GaiaSaver_Apply B
where A.userid=B.userid