mysql 语法 字段比较_MySQL通过group by语句比较两个字段的总和

从表格下方,我希望这些发票的所有项目都是

打包.

表：

mysql> select * from allotment;

+----+------------+---------+-----------+------------+------------+

| id | invoice_id | item_id | total_qty | packed_qty | created |

+----+------------+---------+-----------+------------+------------+

| 1 | 4 | 26 | 4 | 4 | 2016-08-31 |

| 2 | 4 | 38 | 1 | 1 | 2016-08-31 |

| 3 | 5 | 39 | 16 | 8 | 2016-08-31 |

| 4 | 5 | 2 | 2 | 5 | 2016-08-31 |

+----+------------+---------+-----------+------------+------------+

我的查询：

mysql> SELECT invoice_id, created FROM allotment

where sum(allotment.total_qty)=sum(allotment.packed_qty)

GROUP BY invoice_id;

[**ERROR 1111 (HY000): Invalid use of group function]

我已经应用了很多方法,但是没有用.其实我需要比较

针对“ total_qty之和”和“ packed_qty之和”

“发票ID”.

我的预期结果：

+------------+------------+

| invoice_id | created |

+------------+------------+

| 4 | 2016-08-31 |

Logic: Invoice_id 4, total_item = 4+1 and total_packed= 4+1

[select where total_item==total_packed]

有什么办法可以从“分配”表中获得此结果？