17,377
社区成员
发帖
与我相关
我的任务
分享
你的意思应该是要在结果中剔除重复的,这样的话,需要对查询结果的所有字段进行GROUP BY (聚合函数也具有这种特性,所以加了聚合函数的就不用加进GROUP BY 中了)。这样写就不会错了:
SELECT NEWFLOWCONTROL.NUMBERR, order_detail.photonum, order_detail.WARE_NUM
FROM order_detail, NEWFLOWCONTROL
WHERE NEWFLOWCONTROL.NUMBERR = order_detail.NUMBERR
AND NEWFLOWCONTROL.NSTATE = '0'
GROUP BY NEWFLOWCONTROL.NUMBERR,, order_detail.photonum, order_detail.WARE_NUM
或者用DISTINCT 也可以达到要求:
SELECT DISTINCT NEWFLOWCONTROL.NUMBERR, order_detail.photonum, order_detail.WARE_NUM
FROM order_detail, NEWFLOWCONTROL
WHERE NEWFLOWCONTROL.NUMBERR = order_detail.NUMBERR
AND NEWFLOWCONTROL.NSTATE = '0'