Здравствуйте Matt
ME> CREATE TABLE `T1` ( ME> `guid` smallint(5) unsigned NOT NULL default '0', ME> `qid` smallint(5) unsigned NOT NULL default '0', ME> `a` tinyint(2) NOT NULL default '-2', ME> `d` tinyint(2) NOT NULL default '-2', ME> KEY `IX_FW_qid` (`qid`), ME> KEY `IX_FW_d` (`d`) ME> ) TYPE=HEAP ME> CREATE TABLE `T2` ( ME> `guid` mediumint(8) unsigned NOT NULL default '0', ME> `qid` tinyint(3) unsigned NOT NULL default '0', ME> `a` tinyint(4) NOT NULL default '0', ME> `d` decimal(1,0) unsigned NOT NULL default '0', ME> PRIMARY KEY (`guid`,`qid`), ME> KEY `IX_s23aw_d` (`d`), ME> KEY `IX_s23aw_qid` (`qid`) ME> ) TYPE=HEAP ME> SELECT T1.guid, sum(T1.d + T2.d) as theSum ME> FROM T1, T2 ME> WHERE T1.qid=T2.qid ME> GROUP BY T1.guid make key in T1: KEY `zzzz` (qid,guid ) and change table type to MyIsam for both table. Michael Monashev http://softsearch.ru/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
