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