一、统计

一、统计

SELECT * from Tbl_Loan where  DealTime between '2019-07-15' and '2019-07-19 23:59:59' AND Status='已签约'

SELECT count(*) from Tbl_Loan where  DealTime between '2019-07-15' and '2019-07-19 23:59:59' AND Status='已签约'

SELECT * from Tbl_Loan where ID in(select LoanID FROM Tbl_LoanLog where CreateTime between '2019-07-15' and '2019-07-19 23:59:59' AND Status='已签约')

select * from Tbl_Loan RIGHT JOIN Tbl_LoanLog ON Tbl_Loan.ID=Tbl_LoanLog.LoanID 
where Tbl_LoanLog.CreateTime between '2019-07-15' and '2019-07-19 23:59:59' AND Tbl_LoanLog.status='已签约'