> -----Original Message----- > From: I am on the top of the world! Borlange University > [mailto:michael3832628@xxxxxxxxx] > Sent: Monday, January 17, 2011 11:33 PM > To: php-general@xxxxxxxxxxxxx > Subject: how to avoid using temporary? > > heres my sql query: > EXPLAIN SELECT t1.szs_guige,SUM(t1.szs_shuliang) FROM szs_ck_ruku_items > t1,szs_ck_ruku t2 WHERE t1.szs_rukubianhao = t2.szs_rukubianhao AND > t2.szs_date>'2010-10-23' GROUP BY t1.szs_guige ORDER BY null > <snip> This is PHP list. Not a SQL list/discussion. Try asking the forum relating to the DBMS you're using. Regards, Tommy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
