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

[步骤]

[结果]

策略：8504 

ERP数据库查询有订单，但listing没有销量的数据，创建的策略。

SELECT * FROM dbo.RB_OrderInfo (NOLOCK) x
INNER JOIN RB_OrderList (NOLOCK) ol ON
x.CustomerID=ol.CustomerID AND x.OrderCode=ol.OrderCode
INNER JOIN dbo.RB_OrderSource (NOLOCK) z ON x.OrderSourceID=z.ID
LEFT JOIN RB_Report_OrderSourceSKUDay (NOLOCK) y ON
x.CustomerID=y.CustomerID AND y.OrderSourceSKU=ol.SellerSKU
AND y.OrderSourceID=x.OrderSourceID
WHERE x.CustomerID=1 AND z.OrderSourceType=57
AND x.AddTIme>'2023-07-12'
AND y.ID IS NULL

[期望]