You must list each field in the GROUP BY:
GROUP BY b.Name, a.id_no, a.name, b.account... etc.
> 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!!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer