I have two currencies,CAD(canadian dollars) and USD(US dollars) and one user can sit on different tables.
Is there a way by which I can get the sub-total of each user for both USD and CAD for all the tables he is
playing In.Or,I've to use java and compute the sum,like this:
Thanks andy,but that wud give me a total of USD and CAD for all the users.But i need the total for each user.I know in Oracle ,this is the way to do it:
sum(amount) on user_id.
This will generate a new row whenever the user_id changes,and compute the sum(no matter in USD or CAD,i am just showin givin an example) for the particular user before moving on to the next user.
Can you help me now?