select 订单号,sum(单价*数量)as 总金额;
from order_detail group by 订单号;
into cursor xx
select 客户号,order_list.订单号,订购日期,xx.总金额;
from order_list inner join xx;
on order_list.订单号=xx.订单号;
where order_list.总金额<>xx.总金额;
order by 4;
into table od_mod
from order_detail group by 订单号;
into cursor xx
select 客户号,order_list.订单号,订购日期,xx.总金额;
from order_list inner join xx;
on order_list.订单号=xx.订单号;
where order_list.总金额<>xx.总金额;
order by 4;
into table od_mod
