[步骤]
6590637 分组
SELECT o.CustomerID,a.OrderSourceType,o.WareHouseID,o.Country,k.SKU,Max(K.ID) AS ID,CAST(o.CustomerID as varchar)+CAST(a.OrderSourceType as varchar)+CAST(o.WareHouseID as varchar)+o.Country+k.SKU as CID FROM RB_OrderInfo o (nolock) INNER JOIN RB_OrderSource a (nolock) ON o.CustomerID = a.CustomerID AND o.OrdersourceID = a.ID INNER JOIN RB_OrderList k (nolock) ON o.CustomerID = k.CustomerID AND o.OrderCode = k.OrderCode WHERE o.CustomerID = 1 AND o.OrderState > 0 AND o.ProductNumber = 1 AND o.IsPay = 1 AND o.IsStockOrder = 0 AND o.DownLoadUpdateTime > '2000-01-01' AND o.PayTime < Dateadd(d, -1, Getdate()) AND Isnull(o.TotalPrice, 0) > 0 AND k.ProductNum+k.ProductNumUpdate>0 GROUP BY o.CustomerID,a.OrderSourceType,o.WareHouseID,o.Country,k.SKU
[结果]
[期望]
同步ERP 数据 不能用逻辑 ，消耗大量资源