Hi i am trying to make a nestled query to get the total sum of my accounts. My question is how to make a query to handle this?
I have two tables.
tbAccount
lngAccountID strName
1 A1
2 A2
3 A3
4 A4
Now I want to SUM lngPrice for all the accounts.
tbTransaction
lngTransID lngAccountID lngPrice
1 2 500
2 2 250
3 1 100
4 2 175
5 3 100
6 4 200
7 3 100
8 1 800
I want to present it as follow.
Account Total
A1 900
A2 925
A3 200
A4 200
How do I do this?
Thanks for a great forum!
//Linkan
I have two tables.
tbAccount
lngAccountID strName
1 A1
2 A2
3 A3
4 A4
Now I want to SUM lngPrice for all the accounts.
tbTransaction
lngTransID lngAccountID lngPrice
1 2 500
2 2 250
3 1 100
4 2 175
5 3 100
6 4 200
7 3 100
8 1 800
I want to present it as follow.
Account Total
A1 900
A2 925
A3 200
A4 200
How do I do this?
Thanks for a great forum!
//Linkan