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

解决SQL字段重复问题

最新推荐文章于 2024-09-28 22:33:14 发布

weixin_34168880

最新推荐文章于 2024-09-28 22:33:14 发布

阅读量73

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/jonyjaja/archive/2007/04/26/SQL.html

本文讨论了一个具体的SQL查询问题，即如何避免同一字段在查询结果中重复出现，并且提出了需要根据EventType字段的不同值来区分已有截留和已有次品数量的具体需求。

请大家帮忙~~~~~~~~~~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'。

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