Replymessage unavailable
SELECT COALESCE(m3.bal, 0) AS beginning_of_month
FROM tlm_gt_custom m1
LEFT JOIN tlm_gt_custom m3 ON m3.acc = m1.acc
AND m3.ccy = m1.ccy
AND TRUNC(m3.val_dt) >= TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')
WHERE m1.ccy = 'USD'
AND m1.acc = '9820084080783001'
GROUP BY m1.ccy, m1.acc, m3.bal;