> 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 >>fabio