摘要:1、insert into order select distinct 标识ID from source_table
2、insert into ORDER_CAT select SUM(数量*单价),source_table.分类号,order.ORDERID
from source_table inner join order
on source_table.标识ID = order.标识ID
group by source_table.分类号,order.ORDERID
3、我就不写了,就是用order, ORDER_CAT 和源表关联即可。
Good Luck!...[
阅读全文]