* Roleigh Martin > mysql> insert h2 > -> select h1.word, ' ', 0 > -> from h1 left join h2 ah2 on h1.word = ah2.word > -> where ah2.word is NULL; > ERROR 1093: INSERT TABLE 'h2' isn't allowed in FROM table list
You can not select from the table you are inserting to. Use a temporary table: create temporary table tmp1 select ... ; insert into h2 select * from tmp1; -- Roger --------------------------------------------------------------------- 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