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 | > +----------+--------+-------+----------+ > > how can i also show a grand total for the ticket (without changing the > table structure)? i've tried with no success to use SUM() to do this. > would i even use SUM()?
This has got nothing to do with joins, you can have the same problem in a single table: http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
