update A
set A.orgid=B.organization
from SH_STOCK_product_out_stock A, JsInfo.dbo.shsp_out_stock B
where A.autonum=B.autonum
update A
set A.orgname= B.name
from SH_STOCK_product_in_stock A, organization B
where A.orgid=B.symbol
set A.orgid=B.organization
from SH_STOCK_product_out_stock A, JsInfo.dbo.shsp_out_stock B
where A.autonum=B.autonum
update A
set A.orgname= B.name
from SH_STOCK_product_in_stock A, organization B
where A.orgid=B.symbol
扫一扫
2464
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
