select MAX(a.id_no), MAX(a.name), MAX(b.account), b.name, sum(a.inv_total), MAX(a.inv_status) ;
from customer_invoices a, customer_accounts b;
where inv_status=lcoverduestatus and a.id_no=gnclientid and a.name=b.account;
group by b.name ;
into cursor sql_collections readwrite