语句1:
select t.mediid,t.mediname,t.showunit,sum(t.showquan) CalQuan,t.price,sum(t.amount) CalAmount
from amsh_mixdtl t
inner join amsh_mix mix on mix.ourid=t.mainid
where mix.recipeid in(select ad.recipeid from out_sendmediaddress ad where ad.orderid is not null and ad.iscancel=0)
group by t.mediid,t.mediname,t.showunit,t.price;语句2:
select t.mediid,t.mediname,t.showunit,sum(t.showquan) CalQuan,t.price,sum(t.amount) CalAmount
from amsh_mixdtl t
inner join amsh_mix mix on mix.ourid=t.mainid
where exists (select 1 from out_sendmediaddress ad where ad.orderid is not null and ad.iscancel=0 and mix.recipeid = ad.recipeid)
group by t.mediid,t.mediname,t.showunit,t.price;
select t.mediid,t.mediname,t.showunit,sum(t.showquan) CalQuan,t.price,sum(t.amount) CalAmount
from amsh_mixdtl t
inner join amsh_mix mix on mix.ourid=t.mainid
where mix.recipeid in(select ad.recipeid from out_sendmediaddress ad where ad.orderid is not null and ad.iscancel=0)
group by t.mediid,t.mediname,t.showunit,t.price;语句2:
select t.mediid,t.mediname,t.showunit,sum(t.showquan) CalQuan,t.price,sum(t.amount) CalAmount
from amsh_mixdtl t
inner join amsh_mix mix on mix.ourid=t.mainid
where exists (select 1 from out_sendmediaddress ad where ad.orderid is not null and ad.iscancel=0 and mix.recipeid = ad.recipeid)
group by t.mediid,t.mediname,t.showunit,t.price;
解决方案 »
- 请教一个分组语句
- JAVA+ORACLE数据归属问题
- oracle中在已经创建好的标中制定位置增加字段的sql语句怎么写,谢谢!在线等......
- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$关于ORA-00937 不是单组分组函数 问题,在线等,解决即给分$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
- 层与层之间的分组排序,比较困难,检验下能力
- 在p4的机器上装oracle 8i,补丁到哪里去下载啊?
- ORACLE的配置问题,高手请进!
- 事务的问题
- 无法安装oracle 8i,为什么?(windows 2000 SP2,无法进入安装界面)
- 请问一个效率问题
- oracle触发器,一张表在录入时,一个字段的值如何直接取另一个表字段的值
- 执行报错,求指教
外小内大用Exists