SQL SELECT QUESTION

[TSO456]

Hello,

I would appreciate your help in writting a SQL that would select from the client ID (Client ID is not unique) and sum the amount column for that client. For Example the resulting query for client ID (A) would be $600 (500+100). The resulting query for client ID (B) would be $20.

The resulting query should display the client ID and the total $ amount for that client.

Client ID Purchase $Amount

A Apples $500
A Oranges $100
B Apples $20
C Oranges $80
D Apples $60

Thank you

 

[Cagliostro]

select [Client ID], sum($Amount) from YourTablesNameHere grou by [Client ID] Ion Filipski

filipski@excite.com

 

[karluk]

Hi, TSO456

This question seems virtually identical to the one you posted earlier in thread220-124719. Could you give us some detail as to whether the proposed "group by" solution worked? If not, what went wrong? Is the current query really the same, or is there some subtle difference that I'm not seeing?

 

[TSO456]

I found that the client ID is not unique.

Thanks

 

[karluk]

Ah, I see. However I think you will find that "group by" will still work. Have you given it a try?

 

[TSO456]

It worked. I really appreciate your help.

Have a nice weekend!!