From: Thimble Smith
Date: March 18 1999 11:53pm
Subject: Re: Can Mysql use JOIN in UPDATE statements?
List-Archive: http://lists.mysql.com/mysql/533
Message-Id: <19990318165327.B17225@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Thu, Mar 18, 1999 at 05:31:32PM -0600, Brandon Shuey wrote:
> If what is the format?

Nope.  Update works on a single table (it's SQL).  For now you
can do something like:

    INSERT INTO temporary_table SELECT <your choice, using joins>;
    DELETE FROM original_table WHERE ...;
    INSERT INTO temporary_table SELECT * from temporary_table;
    DROP TABLE temporary_table;

Tim