select a.id_no, a.name, b.account, b.name, sum(a.inv_total), 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

is there anyway to do this without having to set it to 7.0 behavior? I have tried everything that I could find. Thanks!!