php - 显示没有重复的数据并计算重复项

Question

我有两个表如下

query :-

Select ORDER_NO From Posuma Where CUST_CODE = '18'   

result :-

 ORDER_NO 
 ---------  
 1014  
 1029

现在，我已经在另一个表名称 polna 中搜索具有相关订单号的产品...

query :-

SELECT ITEM_CODE, ITEM_DESC, QTY FROM `polna` WHERE `ORDER_NO`=1014 ORDER BY `ORDER_NO` ASC

result:-

ITEM_CODE | ITEM_DESC    | QTY
--------- | -------------| ----
32-224    | PLATE STAND  | 10                                   
32-227    | SCONCE       | 5                                    
32-244    | PLATE STAND  | 10                                   
32-245    | PLATE STAND  | 5                                    

我想要以下结果:

 ITEM_CODE | ITEM_DESC   | QTY
 --------- | ----------- | ----
 32-224    | PLATE STAND | 20
 32-245    | PLATE STAND | 10
 32-227    | SCONCE      | 5

Answer 1

请尝试以下查询，也许对您有用。我认为需要在查询中添加 GROUP BY。

SELECT ITEM_CODE, ITEM_DESC, SUM(QTY) as QTY FROM polna WHERE ORDER_NO=1014 GROUP BY ITEM_CODE ORDER BY ORDER_NO ASC

尝试让我知道。