查出所有产品的库存 ,库存=入库-出库+退货,sql语句该怎么写?select r.pronum,sum(r.num)-sum(f.num)+sum(t.num) from Ruku r,Fahuo f,Tuihuo t group by r.pronum 这条语句查出的数据是不正确的!求解!!!!
解决方案 »
- OracleDBConsoleorcl服务无法启动
- oracle动态sql 紧急求助
- 查询出人数最多的那个部门的部门编号和部门名称
- Oracle SQL语句
- sql编写function
- orcale的资料档案库和数据库有什么不同啊??
- 求教一条24小时连锁店的统计问题
- 一张表怎么left outer join 两张表呢?
- 难:如何提高此SQL的执行效率?
- win2002下面能装Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP 这个版本嘛?
- oracle 自学问题
- Java里面插入Oracle语句怎么写(带自增,带日期)
select r.pronum,sum(r.num)-sum(f.num)+sum(t.num) from Ruku r,Fahuo f,Tuihuo t
where r.pronum = f.pronum and f.pronum = t.pronum
group by r.pronum
from (select pronum,SUM(num) as num from Ruku group by pronum) r
left join (select pronum,SUM(num) as num from Fahuo group by pronum)f
left join (select pronum,SUM(num) as num from Tuihuo group by pronum)
group by r.pronum
from (select pronum,SUM(num) as num from Ruku group by pronum) r
left join (select pronum,SUM(num) as num from Fahuo group by pronum)f on r.pronum=f.pronum
left join (select pronum,SUM(num) as num from Tuihuo group by pronum)t on r.pronum=t.pronum
group by r.pronum
SELECT t1.pronum, t1.num - NVL (t2.num, 0) + NVL (t3.num, 0)
FROM ( SELECT r.pronum, SUM (r.num) num
FROM Ruku r
GROUP BY r.pronum) t1,
( SELECT f.pronum, SUM (f.num) num
FROM Fahuo f
GROUP BY f.pronum) t2,
( SELECT t.pronum, SUM (t.num) num
FROM Tuihuo t
GROUP BY t.pronum) t3
WHERE t1.pronum = t2.pronum(+) AND t1.pronum = t3.pronum(+)