Re: Can Mysql use JOIN in UPDATE statements?

[Thimble Smith]

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