I was reading somewhere that MySQL 4.1 UPDATE syntax will allow update to table with values from another table in the following manner:
update client, zip set client.st = zip.st, client.city = zip.city where client.zip = zip.zip;
Is there a creative way to do this in 4.0.11?
Sure. Just issue the query you show above. Multi-table updates actually were implemented in 4.0.2.
Or did you try it and it didn't work?
chas
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php