Very close. Only one table may be updated per UPDATE statement.
Doug On Sun, 23 Mar 2003 00:52:59 -0000, [EMAIL PROTECTED] wrote: >Hi > >I may be way off base here but - why do you reference IMPORT_USERS in your >UPDATE statement? You aren't updating any columns in that table. > >Regards, > >Sal > > >> -----Original Message----- >> From: MySQL [mailto:[EMAIL PROTECTED] >> Sent: 12 March 2003 22:33 >> To: MySQL >> Subject: UPDATE syntax help >> >> >> Hi all, I am having a little UPDATE syntax issue. According >> to the manual >> >> UPDATE EBA_USERS, IMPORT_USERS >> SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID, >> EBA_USERS.REP_LOCATION_ID = IMPORT_USERS.REP_LOCATION_ID, >> EBA_USERS.REP_FIRST_NAME = IMPORT_USERS.REP_FIRST_NAME, >> EBA_USERS.REP_LAST_NAME = IMPORT_USERS.REP_LAST_NAME, >> EBA_USERS.REP_DISABLED = IMPORT_USERS.REP_DISABLED >> WHERE EBA_USERS.REP_ID = IMPORT_USERS.REP_ID >> >> should work (as I understand it ;-) but I get the error >> >> ERROR 1064: You have an error in your SQL syntax near ' IMPORT_USERS >> SET EBA_USERS.HUB_ID = IIMPORT_USERS.HUB_ID, >> EBA_USERS.REP_LOCATION_ID = >> IMPO' at line 1 >> >> I did note in the comments section at the bottom someone else with >> same/similar problem, but have been unable to find a thread >> in the mail >> archive. My apologies if this has been dealt with already, >> or a workaround >> suggested... >> >> MySQL 3.23.51-nt on a Win2K box >> MyODBC 3.51 >> >> Thanks >> >> Jeff Creed >> Throbware >> >> (0417) 797 592 >> http://www.throbware.com.au >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]