[步骤]

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

[结果]

[期望]