SQL 分析 谢谢!

Question

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是怎么写的 谢谢!!

Answer 1

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 LOAN_CASH join CASH 
              on LOAN_CASH.COLLECTION_ID = CASH.COLLECTION_ID
          join BORROWER 
              on CASH.BORROWER_ID = BORROWER.BORROWER_ID     

Answer 2

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 LOAN_CASH join CASH 
              on LOAN_CASH.COLLECTION_ID = CASH.COLLECTION_ID
          join BORROWER 
              on CASH.BORROWER_ID = BORROWER.BORROWER_ID     

Answer 3

老大 您把我给的又抄了遍啊.. 我的意思说在DAO层是怎么写的..