Sum Problem

[sleezy]

I'm trying to Sum Transactions but I have a small problem that I need advice on. Please see attached file

[rmiao]

What is FNS_tbTransYaap? Any relation to Transactions table?

[mikr0s]

SELECT a.Client, SUM(b.Amount) AS OutStandingBal
FROM tbTransactions a
LEFT JOIN tbTransactions b ON a.Client = b.Client AND (a.LoanRefId = b.LoanRefId OR a.LoanRefId = b.LoanRefId + 'R')
GROUP BY a.Client

--HTH--