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 > > > --------------------------------------------------------------------- > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]