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 for SubTotal?
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 table5;
+--------+------+------------+
| code | qty | subtotal |
+--------+------+------------+
| 100 | 30 | 30 |
| 200 | 20 | 50 |
| 300 | 25 | 75 |
+--------+------+------------+
3 rows in set (0.00 sec)
mysql>
I hope that it helps you
Regards!
-----Mensaje original-----
De: The Nice Spider [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 22 de Noviembre de 2005 05:27 p.m.
Para: mysql@lists.mysql.com
Asunto: How to SUM every row for SubTotal?
If I have table like:
CODE QTY
100 30
200 20
300 25
and I want a result like:
CODE QTY SUBTOTAL
100 30 30
200 20 50 (this come from 30+20)
300 25 75 (this come from 50+25)
How to write query like that?
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]