hey, Previously I post my question. But it wasn't helped. So I tried own and make sum query.
It's not generate 0 value records. can anyone hep me ?
select loan.loan_id as 'Loan ID' ,loan.customer_name as 'Customer Name' ,loan.total_amount as 'Total Amount' ,ifnull(sum(settlement.amount),0) as 'Total Received' ,((loan.total_amount)-ifnull(sum(settlement.amount), 0))as 'Total Due' from loan inner join settlement on loan.loan_id = settlement.loan_id where loan.collector_name='kapoor' group by loan.loan_id
By this code 2 records shows. But there is another loan collect by kapoor. And that loan still not collected ant payment. So I wanted to show Total Received = 0
Can help ?