Multiple table update is only supported from 4.04 or above. If you are using 3.x, I think you should put the result into another table, delete MSI_List and rename the table to MSI_List.
I would also very interested to know whether there exist a more elegant solution for 3.x. Best regards, > sql > > I have a zip code db named "MSI_Zipcodes that contains > > city > state > zipcode (index) > > I also have a db named "MSI_List" that contains > > ID (index) > email > city(empty) > state(empty) > zip > > My problem is: > > How can i bring the proper info from "MSI_Zipcodes"(city and state) > and enter it (city and state) into the empty fields of "MSI_List" in > accordance with the zip code in "MSI_List"? > > Thanks in advance! > > Todd Clemmer > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --------------------------------------------------------------------- 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