没测试,你试试吧
Select WC.BarCode,WC.Name,WC.WaresCount,(WC.WaresCount-Sc.WaresCount) ChangeCount,
Change1,
Change2,
Change3,
Change4,
Change5,
Change6,
Change7, '20020101' CheckDate
from StoreCheckold_cent SC,Wares_cent WC,StoreCheckDetail_cent WCS,
(Select WaresCount Change1 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='A'),
(Select WaresCount Change2 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='B'),
(Select WaresCount Change3 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='G'),
(Select WaresCount Change4 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='C'),
(Select WaresCount Change5 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='D'),
(Select WaresCount Change6 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='E'),
(Select WaresCount Change7 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='F')
Where WC.BarCode=SC.BarCode and WC.WaresCount<>SC.WaresCount;
Select WC.BarCode,WC.Name,WC.WaresCount,(WC.WaresCount-Sc.WaresCount) ChangeCount,
Change1,
Change2,
Change3,
Change4,
Change5,
Change6,
Change7, '20020101' CheckDate
from StoreCheckold_cent SC,Wares_cent WC,StoreCheckDetail_cent WCS,
(Select WaresCount Change1 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='A'),
(Select WaresCount Change2 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='B'),
(Select WaresCount Change3 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='G'),
(Select WaresCount Change4 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='C'),
(Select WaresCount Change5 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='D'),
(Select WaresCount Change6 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='E'),
(Select WaresCount Change7 From StoreCheckDetail_cent,Wares_cent WC Where BarCode=WC.BarCode and Type='F')
Where WC.BarCode=SC.BarCode and WC.WaresCount<>SC.WaresCount;
解决方案 »
- 从oracle10client 连接到oracle9备份的问题
- Oracle 10g 通过expdp导出的包,可以导入11g吗?如何导入?
- 关于ORACLE分区遇到的问题
- 關于監聽器
- ORACEL存储过程执行UPDATE
- 求一SQL写法
- 正版的ORACLE8i的盘,现在在任何机子上安装不上,以前用该盘装过ORACLE,不是盘的问题,我试了几个ORACLE的盘在几个不同的机子上,都安装
- 关于PL/SQL Developer的问题。
- 50的问题,对于你来说,简单!!
- 如何在DATE型字段后面加上NUMBER型字段,ORACLE总是将他们当数字加起来.
- sql语句建树
- pl/sql变量名和栏名一致的情况
你的版本不高。