From: Thimble Smith Date: March 18 1999 11:56pm Subject: Re: Can Mysql use JOIN in UPDATE statements? List-Archive: http://lists.mysql.com/mysql/535 Message-Id: <19990318165620.C17225@desert.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii On Thu, Mar 18, 1999 at 04:53:27PM -0700, Thimble Smith wrote: > INSERT INTO temporary_table SELECT * from temporary_table; Err... INSERT INTO original_table SELECT * from temporary_table; Tim