SELECT b.bra_code, b.bra_location, at.acctyp_code, at.acctyp_desc, if(at.acctype_code, SUM(a.accnt_bal), '$0') AS "Total Current Value"
FROM BRANCH b, CUSTOMER c, ACCOUNT a LEFT OUTER JOIN ACCTYPE at on at.acctyp_code = a.acctyp_code
WHERE c.cust_no = a.cust_no
  AND c.bra_code = b.bra_code
  AND at.acctyp_code = a.acctyp_code
GROUP BY b.bra_code, b.bra_location, at.acctyp_code, at.acctyp_desc
ORDER BY b.bra_code;