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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Dave Kennedy" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
