22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT i.ClientId --,p.*
FROM dbo.V_WMS_Inventory AS i
inner JOIN
(
SELECT prod.Id
FROM dbo.T_WMS_Product AS prod with(nolock) inner JOIN
dbo.T_CMN_Client AS c with(nolock) ON prod.ClientID = c.Id LEFT OUTER JOIN
dbo.T_WMS_Product_Category AS pc with(nolock) ON pc.Category = prod.ProdCategory
)p
ON i.ProductId = p.Id
--i 后加 with(nolock) 试试
SELECT i.ClientId --,p.*
FROM dbo.V_WMS_Inventory AS i WITH(NOLOCK)
INNER JOIN
(
SELECT prod.Id
FROM dbo.T_WMS_Product AS prod with(nolock) inner JOIN
dbo.T_CMN_Client AS c with(nolock) ON prod.ClientID = c.Id LEFT OUTER JOIN
dbo.T_WMS_Product_Category AS pc with(nolock) ON pc.Category = prod.ProdCategory
) AS p
ON i.ProductId = p.Id