一二三四五吧 关注:190贴子:1,679
  • 1回复贴,共1

1231241241243123

只看楼主收藏回复

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


1楼2012-12-01 14:59回复
    新人报道,一直默默签到


    2楼2012-12-10 08:45
    回复