Hi Einar

try

select invnum,name,SUM(qty) from Mytable where invnum=="001" into cursor myCursor group by name

Nick Mason

>Assume this table:
>

>invnum    name    qty
>------    ----    ---
>001       AA        2
>002       AA        3
>001       BB        1
>001       AA        5
>002       BB        6
>001       CC        7
>

>
>Currently I issue a SQL select like this:
>
>

>select * from myTable where invnum=="001" into cursor myCursor readwrite
>

>then I use the TOTAL command on myCursor to get the folowing result:
>
>

>invnum    name    qty
>------    ----    ---
>001       AA        7
>001       BB        1
>001       CC        7
>

>
>My question is: Is there any way to incorporate the total command into the SQL select statement to output the desired totaled table?
>
>Any help/comments are appreciated.
>
>Einar