批量修改数据且要依附每三个表的做法:
SQL:
update a set a.expressid = b.expressid,a.t1=b.t1
from salesOrderolds a, salesOrderold b where a.orderid=b.orderid
批量修改数据且要依附每三个表的做法:
SQL:
update a set a.expressid = b.expressid,a.t1=b.t1
from salesOrderolds a, salesOrderold b where a.orderid=b.orderid