addition with a do while loop?

[siobhan]

I have four tables. In each table is a score field. I need to add all rows in the score field (each user will submit any number of scores).

Next, I need to add the results of these sums into a grand total for each user.

I know how to add separate fields together, even from separate tables, but I'm not sure about how to add rows in the same field. Could someone possibly direct me to some sample code for this?

siobhan

[Weedpacket]

SQL has a SUM function that will add the values of a given field for all selected records. Look up the documentation for your DBMS for details on how to use it.