SQLquery: delimiter // - #1064 error

Windows XP phpMyAdmin 2.7.0-rc1 MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED] The DELIMITER statement works in the command line, but not in phpmyadmin (see error below) mysql> DELIMITER // mysql> use mysql // Database changed mysql> PHPmyadmin === DELIMITER

Sum() unequal number of rows

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 corre