Re: basic sql join question...

[Philip George]

On May 30, 2005, at 1:28 AM, [EMAIL PROTECTED] wrote:

you can just play :

  set @total:=0;
  select name,price,quantity, price*quantity as
  subtotal,@total:[EMAIL PROTECTED]
  from fruits;

select @total as "grand total";

works great.  thanks very, very much.

- philip



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]