SELECT a.*, ac.CurrTotal FROM (SELECT T1.Account, Isnull((SELECT SUM(T3.Debit - T3.Credit) FROM OJDT T2
INNER JOIN JDT1 T3 ON T2.TransId = T3.TransId
WHERE DateDiff(dd,T2.RefDate,'20200821') > 0 AND T3.Account LIKE T1.Account
GROUP BY T3.Account),0) ...