问题描述:
政策合规,食品安全,店铺过滤部门为742错误
数据:
SELECT DISTINCT
a.ID AS OrderSourceID,
a.OrderSourceName,
c.ID,
c.DeptFullPath
FROM RB_OrderSource a (NOLOCK)
left JOIN RB_Admin b (NOLOCK)
ON a.CustomerID = b.CustomerID
AND a.SaleAdminID = b.ID
left JOIN RB_Department c (NOLOCK)
ON b.CustomerID = c.CustomerID
AND b.DepartmentID = c.ID
WHERE a.CustomerID = 1
AND a.IsActive = 1
AND a.SourceStatus = 0
AND a.ChannelPlatformStatus = 0
AND a.IsDelete = 0
AND a.OrderSourceType = 1
AND a.ID IN (
16606
)


