but it can't work if multiple tables.
how it can use for multiple tables?
- Original Message -
From: ISC Edwin Cruz [EMAIL PROTECTED]
To: 'The Nice Spider' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, November 23, 2005 7:13 AM
Subject: RE: How to SUM every row
mysql select * from table5;
++--+
| code | qty |
++--+
|100 | 30 |
|200 | 20 |
|300 | 25 |
++--+
3 rows in set (0.00 sec)
mysql set @a=0;
Query OK, 0 rows affected (0.05 sec)
mysql select code,qty,@a:[EMAIL PROTECTED] as subtotal from