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
请问上面一条语句出什么错?
请问上面一条语句出什么错?
那么其余的字段要有sum,count,min,max等相关的函数
你的意思应该是要在结果中剔除重复的,这样的话,需要对查询结果的所有字段进行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'