Hi Philip,
what yoy called gand total is in @total for evevy row.
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;
that's all !
Mathias
Selon Philip George [EMAIL
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
re-send :
Hi,
you can use mysql variables :
set @total:=0;
select name,price,quantity, price*quantity as
subtotal,@total:[EMAIL PROTECTED]
from fruits;
++---+--+--+---+
| name | price | quantity | subtotal | @total:[EMAIL
On 5/29/05, Philip George [EMAIL PROTECTED] wrote:
+--++---+--+
| quantity | name | price | subtotal |
+--++---+--+
|1 | orange | 0.97 | 0.97 |
|3 | pear | 1.09 | 3.27 |
On May 29, 2005, at 1:41 AM, Jochem van Dieten wrote:
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
already read that. the join in my example is more complicated than
anything depicted on that page.
please explain.
- philip
--
MySQL General Mailing List
For list
On 5/29/05, Philip George wrote:
On May 29, 2005, at 1:41 AM, Jochem van Dieten wrote:
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
already read that. the join in my example is more complicated than
anything depicted on that page.
The join is irrelevant. Your join returns a
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
already read that. the join in my example is more complicated than
anything depicted on that page.
please explain.
actually i should say that there are no examples of SUM() or AVG() --
or any of the other GROUP BY functions --
The join is irrelevant. Your join returns a resultset and you can just
pretent that resultset is a single table:
SELECT field1, field2, field3
FROM (very complicated join) AS simpletable
GROUP BY ...
WITH ROLLUP
Just copy-pate your join into this and fix the fieldnames.
aaahhh
okay, i'm
On 5/29/05, Philip George wrote:
On 5/29/05, Philip George wrote:
On 5/29/05, Jochem van Dieten wrote:
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
already read that. the join in my example is more complicated than
anything depicted on that page.
please explain.
actually
actually, i've decided this is sort of a moot point, since i can do
this calculation in the client app.
no sql required.
thanks.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re-submitted :
re-send :
Hi,
you can use mysql variables :
set @total:=0;
select name,price,quantity, price*quantity as
subtotal,@total:[EMAIL PROTECTED]
from fruits;
++---+--+--+---+
| name | price | quantity | subtotal
On May 29, 2005, at 2:34 PM, [EMAIL PROTECTED] wrote:
you can use mysql variables :
set @total:=0;
select name,price,quantity, price*quantity as
subtotal,@total:[EMAIL PROTECTED]
from fruits;
++---+--+--
+---+
| name |
Hi,
you can use mysql variables :
set @total:=0;
select name,price,quantity, price*quantity as
subtotal,@total:[EMAIL PROTECTED]
from fruits;
++---+--+--+---+
| name | price | quantity | subtotal | @total:[EMAIL PROTECTED] |
is it okay to post a basic sql join question to this list?
if not, please point me to a list for these types of questions.
thanks.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:
is it okay to post a basic sql join question to this list?
if not, please point me to a list for these types of questions.
thanks.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL
obtained by keeping it in JOIN clauses and using the WHERE only to contain
the include if logic.
hth,
Arthur
-Original Message-
From: Adam Randall [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 21, 2002 5:18 AM
To: [EMAIL PROTECTED]
Subject: Basic SQL join question
Okay, I've
PROTECTED]]
Sent: Saturday, September 21, 2002 5:18 AM
To: [EMAIL PROTECTED]
Subject: Basic SQL join question
Okay, I've thought about this every way I can conceive of, but I
cannot figure out the sql query logic involved in joining three
tables together. Here is what I am trying to do:
I
Subject: RE: Basic SQL join question
SELECT *
FROM Projects
INNER JOIN KeywordLink ON Projects.Id = KeywordLink.Pid
INNER JOIN Keywords KeywordLink.Kid = Keywords.Id
WHERE Keyword LIKE '%historical%' AND
Keyword like '%scenic%';
Out of curiousity, does the order matter?
I have a JOIN
the
clarity obtained by keeping it in JOIN clauses and using the WHERE only
to contain the include if logic.
hth,
Arthur
-Original Message-
From: Adam Randall [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 21, 2002 5:18 AM
To: [EMAIL PROTECTED]
Subject: Basic SQL
Okay, I've thought about this every way I can conceive of, but I
cannot figure out the sql query logic involved in joining three
tables together. Here is what I am trying to do:
I have three tables:
keywords
keywordlink
projects
keywords has these fields:
id
keyword
keywordlink has
20 matches
Mail list logo