how to make sql command????

[bon011]

Hi all,

This is example of table

id type count
1 A 2
1 A 3
1 B 5
2 A 1
2 B 2
3 C 3
3 C 4

How to make SQL select command that will make sum of filed "count". But it must sum rows that have same id and type.

The result should look like this:

id type count
1 A 5
1 B 5
2 A 1
2 B 2
3 C 7

How to do that with sql command?

 

[bon011]

it is Ok

I done it.
It was easy.

 

[Mazufri]

Does anyone has an example of a select instruction and how to open the database. I want to create a recordset and I don't know how.
Thanks in advance.

 

[jimoo]

IF DBUSED('myDatabase') = .F.
* open database
OPEN DATA myDatabase SHARED
ENDIF

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[GriffMG]

Bon011,

Why not pass on what your solution was. Then we can all share in it.

Regards

Griff
Keep [Smile]ing

 

[bon011]

select id, type, sum(count) from mytable group by id, type

That is all