This is my code so far:
到目前为止这是我的代码:
update
A
set
A.NAME= B.NAME,
A.MOBILE = C.MOBILE
A.TOLLFREE = C.NUMBERVALUE
from ACCOUNT A
inner join COMPANY B on a.COMPANYID = B.COMPANYID
inner join PHONE C on B.COMPANYID = C.COMPANYID
where c.TYPEID = '1111'
update