[步骤]

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')
[结果]
[期望]
排查 是否可以用读库
已调整