Brendan Gogarty wrote: > We are running mysql 3.23.58 and I want to do a query with joins > from two tables and then insert the results into the column of a third. [snip]
Shawn Green wrote: > Start from here: > http://dev.mysql.com/doc/mysql/en/update.html > > Updates *are* allowed to use JOINED tables as the "thing to be > updated". [snip] Michael wrote: [snip] > From the manual page Shawn cites: "Starting with MySQL 4.0.4, you can also > perform UPDATE operations that cover multiple tables." So, yes, it's a > version issue. So, to return to my original question ... Is there a workaround or a way of updating from a joined query in <4mysql? I thought perhaps creating a temporary table, but even this doesn't seem to work? There MUST be a way of doing this ... Its an administrative nightmare. Regards, Brendan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]