N1440304 SQL:SELECT DevelopmentName,DevelopmentId
FROM RB_Product_Development ( NOLOCK ) Where CustomerID =1AND CurrentStatus IN ('SuccessfulDevelopment','Completed','DevelopmentFailure','FailureOfDevelopment')
AND Id in(SELECT DISTINCT ProductDevelopmentId
FROM dbo.RB_Product_Development_Status
WHERE CustomerID = pd.CustomerID
AND Status = 'Committed'
AND AddTime >= '2023-11-02'
AND AddTime <= '2023-11-08 23:59:59'
)
AND CurrentStatus IN('PendingAudit' ,'CallBackToBeAudited' ,'Committed') GROUP BY DevelopmentId, DevelopmentName
PARAMS:
MESSAGE:The multi-part identifier "pd.CustomerID" could not be bound.