oracle SQL:
select
t.chargetype,
sum(i.INVOICEAMOUNT) as INVOICEAMOUNTsum,
sum(i.PAYMENTAMOUNT) as PAYMENTAMOUNTsum ,
sum(i.PAYMENTAMOUNT)-sum(i.INVOICEAMOUNT) as chargediffer
from
TBT_RKN_INFORMATION t ,
tbt_rkn_invoice i
where
i.RECKONINGID = t.RECKONINGID and
chargediffer<>0
group by t.chargetype运行提示 chargediffer标识符无效,要怎么解决?
select
t.chargetype,
sum(i.INVOICEAMOUNT) as INVOICEAMOUNTsum,
sum(i.PAYMENTAMOUNT) as PAYMENTAMOUNTsum ,
sum(i.PAYMENTAMOUNT)-sum(i.INVOICEAMOUNT) as chargediffer
from
TBT_RKN_INFORMATION t ,
tbt_rkn_invoice i
where
i.RECKONINGID = t.RECKONINGID and
chargediffer<>0
group by t.chargetype运行提示 chargediffer标识符无效,要怎么解决?
解决方案 »
- 多帐套 多数据库
- 救命啊!存储过程中execute immediate和字符串的用法
- oracle 创建表?
- 远程客户机在net服务名配置中,测试连接服务器不成功!求救!
- SQL 语句 和 系统性能
- 请问如何在oracle中将记录插在表的末尾?
- 為甚麼我update mytable set mydate=to_date(sysdate,'yyyy-mm-dd hh:mi:ss') where id=1 時得到的結果是mydate里只有日期沒有小時分鐘和
- linux下面的oracle的书有下的地方吗?
- 如何实现oracle中表和主键索引分别存放于不同的表空间
- oracle数据库两张表的数据结构一样,如何检查两张表其中一个字段不同的数据
- JDBC访问Oracle问题 。
- cognos配置问题
如没有,是你写错了。
select
t.chargetype,
sum(i.INVOICEAMOUNT) as INVOICEAMOUNTsum,
sum(i.PAYMENTAMOUNT) as PAYMENTAMOUNTsum ,
sum(i.PAYMENTAMOUNT)-sum(i.INVOICEAMOUNT) as chargediffer
from
TBT_RKN_INFORMATION t ,
tbt_rkn_invoice i
where
i.RECKONINGID = t.RECKONINGID and
group by t.chargetype
having sum(i.PAYMENTAMOUNT)-sum(i.INVOICEAMOUNT) <>0