SELECT oi.CustomerID,oi.OrderCode as 系统订单号,oi.ClientOrderCode as 平台订单号,os.SaleAdminName as 销售人员,RB_BusinessTeam.BusinessTeamName as 销售小组
FROM RB_OrderInfo oi (nolock)
LEFT JOIN RB_OrderSource os WITH(nolock)
ON oi.CustomerID = os.CustomerID
AND oi.OrderSourceID = os.ID
LEFT JOIN E_Country e WITH(nolock)
ON oi.Country = e.Shorthand
LEFT JOIN RB_Transport t WITH(nolock)
ON oi.CustomerID = t.CustomerID
AND oi.TransportID = t.ID
LEFT JOIN RB_Transport_API tapi WITH(nolock)
ON t.Transport_API_ID = tapi.ID
AND t.CustomerID = tapi.CustomerID
LEFT JOIN RB_WareHouse wh WITH(nolock)
ON oi.CustomerID = wh.CustomerID
AND oi.WareHouseID = wh.ID
LEFT JOIN RB_OrderList (nolock)
ON oi.CustomerID = RB_OrderList.CustomerID
AND oi.OrderCode = RB_OrderList.OrderCode
AND RB_OrderList.ProductNum + RB_OrderList.ProductNumUpdate > 0
LEFT JOIN RB_Product (nolock)
ON RB_Product.CustomerID = RB_OrderList.CustomerID
AND RB_Product.SKU = RB_OrderList.SKU
LEFT JOIN RB_Product_SupplierPrice WITH(nolock)
ON RB_Product_SupplierPrice.SKU = RB_OrderList.SKU
AND RB_Product_SupplierPrice.CustomerID = RB_OrderList.CustomerID
AND Isnull(RB_Product_SupplierPrice.SKU, '') <> ''
AND RB_Product_SupplierPrice.IsDefault = 1
LEFT JOIN RB_Product_Supplier (nolock)
ON RB_Product_SupplierPrice.SupplierID = RB_Product_Supplier.ID
AND RB_Product_SupplierPrice.CustomerID = RB_Product_Supplier.CustomerID
LEFT JOIN RB_Product_Admin (nolock)
ON RB_OrderList.SKU = RB_Product_Admin.SKU
AND RB_OrderList.CustomerID = RB_Product_Admin.CustomerID
LEFT JOIN (SELECT CustomerID,
SKU,
ShareClientSKU
FROM RB_ProductShare (nolock)
GROUP BY CustomerID,
SKU,
ShareClientSKU) AS rps
ON RB_OrderList.CustomerID = rps.CustomerID
AND RB_OrderList.SKU = rps.SKU
LEFT JOIN RB_Admin rba ON rba.CustomerID = os.CustomerID AND rba.ID = os.SaleAdminID
LEFT JOIN RB_BusinessTeam (nolock)
ON RB_BusinessTeam.ID = rba.BusinessTeamID
INNER JOIN (SELECT distinct CustomerID,OrderSourceID from RB_OrderSource_SaleAdmin WITH(nolock) where Adminid = 5270 and CustomerID = 1) ossa ON ossa.OrderSourceID=oi.OrderSourceID and ossa.CustomerID=oi.CustomerID LEFT JOIN RB_Admin rba ON rba.CustomerID = os.CustomerID AND rba.ID = os.SaleAdminID
WHERE oi.CustomerID = @CustomerID
AND oi.IsStockOrder = 0 AND oi.IsPay = @IsPay AND oi.AddTime >= @StartTime AND oi.AddTime <= @EndTime AND rba.BusinessTeamID IN (8,121,122,123,149,156,164)
PARAMS:@CustomerID = 1 ,@CurrentAdminID = 5270 ,@IsPay = 1 ,@StartTime = 2022/1/1 0:00:00 ,@EndTime = 2022/1/1 23:59:59 ,
MESSAGE:The correlation name 'rba' is specified multiple times in a FROM clause.
自测结果：