Donal With MySQL, temp_explanations MUST exist before you can INSERT INTO it. Based on the assumption that temp_explanations is non-existent, you will have to CREATE TABLE temp_explanations first before running an INSERT INTO.
Hope that helps. Inyang > > > Hello, > I want to do the following query > > INSERT INTO temp_explanations(tip) SELECT tip FROM explanations WHERE > explanations.file=temp_explanations.file AND > explanations.level=temp_explanations.level; > > but I'm getting an 'unknown table temp_explanations' error. > How can I get around this? > Thanks, Donal > -- > For the largest free email in Ireland (25MB) & > File Storage space (20MB), visit http://www.campus.ie > > Powered by Outblaze > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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