Hi, I want to build a temp table which I can query to sum values. If I try "create temporary table tbl_name select some_query_here", then I get an error that tells me that I have an error with my sql syntax near 'temporary table tbl_name select some_query_here'. Am I correct in thinking that this is due to the version of mysql I'm using? (No, I can't upgrade it at this point).
I wasn't successful in finding the answer to my dilemma at www.mysql.com/doc/manual.php. Thanks, Brian --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php