深圳智汇创想科技有限公司

[步骤]

                  select distinct ol.SKU  from  RB_OrderInfo info (nolock)                  inner join RB_OrderInfo_BeikuExpand infob (nolock) on info.CustomerID=infob.CustomerID and info.OrderCode=infob.OrderCode                  inner join RB_OrderList ol (nolock) on  info.CustomerID=ol.CustomerID and info.OrderCode=ol.OrderCode                  WHERE info.CustomerID in (1) and info.IsStockOrder=1 and infob.RestockType=2                   and info.AddTime>=DATEADD(year,-2,getdate())      and ol.sku in ('13934559')  

[结果]

[期望]