select CASH.COLLECTION_ID,CASH.BORROWER_ID,LOAN_CASH.LOAN_ID,CASH.CASH_DATE,CASH.CASH_TYPE,CASH.CURRENCY,LOAN_CASH.AMOUNT,LOAN_CASH.PRINCIPAL,LOAN_CASH.INTEREST,LOAN_CASH.PENALTY from LOAN_CASH,CASH,BORROWER where LOAN_CASH.COLLECTION_ID = CASH.COLLECTION_ID and LOAN_CASH.AMOUNT != 0 and CASH.BORROWER_ID = BORROWER.BORROWER_ID and CASH.BORROWER_ID in (select BORROWER_ID from PEOPLE_BORROWER where USER_ID=3) and CASH.CURRENCY = '801' and LOAN_CASH.PRINCIPAL >= 0 and LOAN_CASH.PRINCIPAL <= 11111通过上面这个帮忙分析一下SQL是怎么写的 谢谢!!
解决方案 »
- 这个sql语句怎么写?
- DBLINK连接,ora-21561报错?
- 从oracle10g 32bit(RED Hat)为客户端,导出oracle11g 64bit(HP UNIX)库里的信息,报错如下
- 复杂的统计sql语句
- 大家看一下这是什么错误啊! ‘错误信息:ORA-01858: 在要求输入数字处找到非数字字符’
- oracle压缩表空间
- 关于oracle建立序列问题?
- 在存储过程中如何创建临时表?
- 没见过我这样送分的!!!!!!!!!!!!!!
- 如何查看oracle11g在何时进行了表空间扩展
- 在PRO*C中查询的栏位名称如何用变量来代替?
- 创建视图出现 ora-00293 未找到预期关键字 急问如何解决?
CASH.BORROWER_ID,
LOAN_CASH.LOAN_ID,
CASH.CASH_DATE,
CASH.CASH_TYPE,
CASH.CURRENCY,
LOAN_CASH.AMOUNT,
LOAN_CASH.PRINCIPAL,
LOAN_CASH.INTEREST,
LOAN_CASH.PENALTY
from LOAN_CASH,
CASH,
BORROWER
where LOAN_CASH.COLLECTION_ID = CASH.COLLECTION_ID
and LOAN_CASH.AMOUNT != 0
and CASH.BORROWER_ID = BORROWER.BORROWER_ID
and CASH.BORROWER_ID in (select BORROWER_ID
from PEOPLE_BORROWER
where USER_ID=3)
and CASH.CURRENCY = '801 '
and LOAN_CASH.PRINCIPAL > = 0
and LOAN_CASH.PRINCIPAL <= 11111 LOAN_CASH join CASH
on LOAN_CASH.COLLECTION_ID = CASH.COLLECTION_ID
join BORROWER
on CASH.BORROWER_ID = BORROWER.BORROWER_ID
CASH.BORROWER_ID,
LOAN_CASH.LOAN_ID,
CASH.CASH_DATE,
CASH.CASH_TYPE,
CASH.CURRENCY,
LOAN_CASH.AMOUNT,
LOAN_CASH.PRINCIPAL,
LOAN_CASH.INTEREST,
LOAN_CASH.PENALTY
from LOAN_CASH,
CASH,
BORROWER
where LOAN_CASH.COLLECTION_ID = CASH.COLLECTION_ID
and LOAN_CASH.AMOUNT != 0
and CASH.BORROWER_ID = BORROWER.BORROWER_ID
and CASH.BORROWER_ID in (select BORROWER_ID
from PEOPLE_BORROWER
where USER_ID=3)
and CASH.CURRENCY = '801 '
and LOAN_CASH.PRINCIPAL > = 0
and LOAN_CASH.PRINCIPAL <= 11111 LOAN_CASH join CASH
on LOAN_CASH.COLLECTION_ID = CASH.COLLECTION_ID
join BORROWER
on CASH.BORROWER_ID = BORROWER.BORROWER_ID