<?php

function get_sql_for_gl_bank_balances_table_dispaly()
{
    $sql = "SELECT CONCAT(bac.bank_account_name, ' / ', bac.bank_account_number) account,
                   SUM(bt.amount) balance   
                    
            FROM ".TB_PREF."bank_trans bt 
                JOIN ".TB_PREF."bank_accounts bac
                    ON bt.bank_act = bac.id 
               
            WHERE 1 = 1
            GROUP BY bt.bank_act";

    return db_query($sql);
}


?>


































































































































































































































































































