richard gray wrote: > On 13/04/2014 20:46, Christoph Becker wrote: >> >> There are no JOIN clauses allowed in UPDATE statements.[1] >> >> On a quick glance it seems to me that your database could need some >> normalization. The database mailing list[2] might be a more appropriate >> place to discuss this topic. >> >> [1] <http://dev.mysql.com/doc/refman/5.7/en/update.html> >> [2] <mailto:php-db@xxxxxxxxxxxxx> > er.. you *can* use a join clause in an update statement ... > > http://stackoverflow.com/questions/15209414/mysql-update-join/15209489#15209489 Oh, I was not aware of that. Thanks for pointing it out. -- Christoph M. Becker -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php