Group by function

[Albert Chow]

Hi,

        In CMP how can I get the same result as of the following SQL statment :-

        select sum(total) from tableA group by shop_id;

        Thanx in advance.

Albert

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".