List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:March 7 2005 8:54pm
Subject:Re: Sum() unequal number of rows
View as plain text  
Since those two queries don't seem to have any relation other than
being from the same table it seems more logical to keep them two
separate queries.


On Mon, 7 Mar 2005 15:30:16 -0500, SGreen@stripped <SGreen@stripped> wrote:
> "Dave Kennedy" <davek@stripped> wrote on 03/06/2005 05:09:36 PM:
> 
> >
> > SELECT sum(col1) AS total1
> > FROM t1
> > GROUP by col1
> >
> > SELECT col1, sum(col2) AS total2
> > FROM t2
> > GROUP by col2
> >
> > Table t1 contains 4 rows to sum for each value in col1
> >
> > Table t2 contains 8 rows to sum for each value in col2
> >
> > If one select statement is used, the result has 8 rows and total2 is
> > correct but the tota11 is summed over 8 rows instead of 4
> >
> > How can they be joined to produce one row total1, total2
> 
> Without actually seeing your actual data it is nearly impossible to help
> you diagnose this issue. Especially since your results seem to match your
> descriptions (4 rows of data in one table = 4 rows of results if you do it
> one way....)
> 
> Please post your table structures (SHOW CREATE TABLE xxx\G) and your
> sample data (SELECT * FROM xxx;), then show us what you think your queries
> SHOULD have given you (your expected results) and we can start to help.
> The xxx in the sample commands was just a placeholder for the actual table
> names of your data.
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
Thread
Sum() unequal number of rowsDave Kennedy6 Mar
  • Re: Sum() unequal number of rowsSGreen7 Mar
    • Re: Sum() unequal number of rowsEric Bergen7 Mar
    • Re: Sum() unequal number of rowsDBA)8 Mar