格式如下:
update co
set co.ref=a.ref, co.ree=a.ree
from openquery(testa,'select * from rstb') co join testbb a
on co.billDate=a.billDate
格式如下:
update co
set co.ref=a.ref, co.ree=a.ree
from openquery(testa,'select * from rstb') co join testbb a
on co.billDate=a.billDate