List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 23 2001 3:45pm
Subject:Re: Query problems
View as plain text  
Use merge tables, or two separate queries.

"Wix,Christian XCW" wrote:
> 
> Hi
> I have two similar tables. (table1 & table2). They contain the columns
> "name", "distance" and "date". Table1 is year 2000 and Table2 year 2001.
> 
> I need to get the total distance for each name.
> For year 2000 I would do this:
> select name, SUM(distance) from table1 group by name;
> 
> How do I do it for both years? (one query)
> 
> Thanks,
> 
> // Chris - Copenhagen
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread72170@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
Query problemsChristian XCW Wix23 Apr
  • RE: Query problemsWarren van der Merwe23 Apr
  • Re: Query problemsGerald Clark23 Apr
Re: Query problemsmeyer23 Apr