SELECT
account_no.account_noid,
account_catagory.description,
account_sub_catagory.description,
account_no.account_name,
account_no.account_number,
FORMAT(Sum(accounts_split.amount),2)
FROM
account_no
Left Join account_catagory ON account_catagory.account_catagoryid = account_no.account_catagoryid
Left Join account_sub_catagory ON account_sub_catagory.account_sub_catagoryid = account_no.account_sub_catagoryid
Left Join accounts_split ON account_no.account_noid = accounts_split.account_noid
GROUP BY
account_no.account_noid,
account_catagory.description,
account_sub_catagory.description,
account_no.account_name,
account_no.account_number