>Hi Donald,
>
>When I try this I do get a total, but it skips some of the customers. Here is the SQL:
>
>select pay_schdate as cur_schdate, ;
> pay_amt as cur_amt, ;
> sum(pay_amt) as cur_tot, ;
> cus_name as cur_name, ;
> cus_addr1 as cur_addr1, ;
> cus_addr2 as cur_addr2, ;
> cus_city as cur_city, ;
> cus_st as cur_st, ;
> cus_zip as cur_zip, ;
> stu_student as cur_student, ;
> stu_acct as cur_acct, ;
> stu_sub as cur_sub ;
> from customer, student, payment ;
> where pay_amt > 0 and ;
> pay_acct = cus_acct and ;
> (pay_acct = stu_acct and pay_sub = stu_sub) and ;
> empty(pay_paydate) ;
> into cursor lscur
>
Paul:

Your statement is kinda confusing. I don't know which fields are coming from which tables. You should try to use the table name with the field names: select table1.field1, table1.field2, table2.field1 from table1,table2 where table1.key = table2.key.

Anyway, did the statement work properly before you added the sum? Are you calling the AQL statement in a method?