现在我有两个表
表1:order
|id | total|
|A001 | |
|A002 | |
表2:goods
|id | price | order_id |
|B001 | 100 | A001 |
|B002 | 200 | A001 |
|B003 | 300 | A002 |
我该怎么样才能将表2(goods)中的price数据根据order_id求和并插入到表1中?
像这样:
|id | total |
|A001 | 300 |
|A002 | 300 |