22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT dbo.T_PIO.PW_No ,
SUM(ISNULL(dbo.T_PIO.PIO_Qty, 0)) AS Qty ,
ISNULL(dbo.T_PIO.TSW_WareHouse,'')TSW_WareHouse
FROM dbo.T_PIO
INNER JOIN dbo.T_AC ON dbo.T_PIO.PIO_ACNo = dbo.T_AC.AC_ID
WHERE T_AC.AC_Show = 'Y'
AND T_PIO.PIO_Show = 'Y'
AND PW_NO <> ''
AND PW_NO IS NOT NULL
GROUP BY dbo.T_PIO.PW_No ,
ISNULL(dbo.T_PIO.TSW_WareHouse,'')
SELECT dbo.T_PIO.PW_No ,
SUM(ISNULL(dbo.T_PIO.PIO_Qty, 0)) AS Qty ,
ISNULL(dbo.T_PIO.TSW_WareHouse,'')TSW_WareHouse
FROM dbo.T_PIO
INNER JOIN dbo.T_AC ON dbo.T_PIO.PIO_ACNo = dbo.T_AC.AC_ID
WHERE T_AC.AC_Show = 'Y'
AND T_PIO.PIO_Show = 'Y'
AND PW_NO <> ''
AND PW_NO IS NOT NULL
GROUP BY dbo.T_PIO.PW_No ,
dbo.T_PIO.TSW_WareHouse