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