请大家帮忙~~~~~~~~~~SQL问题。

SELECT DISTINCT
SUBSTRING(CuttingPR.CuttingColorNO, 0, CHARINDEX('#', CuttingPR.CuttingColorNO)) AS 订单号 ,
CuttingPR.CuttingBatchNO as 裁剪批号 ,
SUBSTRING(CuttingPR.CuttingColorNO,11,6) AS 花色号 ,
MaterialC.Alias as 面料,

CuttingPR.Quantity as 已有截留,
CuttingPR.Quantity as 已有次品
          
FROM
CuttingPiecesRecords as CuttingPR , MaterialCategory as MaterialC                                                                         
WHERE MaterialC.ID in (select SUBSTRING(CuttingColorNO,7,4) AS ID FROM CuttingPiecesRecords
WHERE CuttingPiecesRecords.Quantity<>0 AND CuttingPiecesRecords.EventType='4')
AND SUBSTRING(CuttingPR.CuttingColorNO,11,6) <> ''
AND SUBSTRING(CuttingPR.CuttingColorNO, 0, CHARINDEX('#', CuttingPR.CuttingColorNO)) <> ''

上面是要输出的东西拉。。。但是Quantity字段显示了两次，我本意不是这样的。因为在CuttingPiecesRecords 表中还有一个EventType字段，有'1','2'，然后就是怎么写，才可以让 （已有截留）的条件是EventType='1',而（已有次品）的条件是EventType='2'。

    `````````````````````````````````````在线等大家的帮忙```````````````````````````````````````````