That explains it then.... D'OH Is there a workaround? Thanks :-) ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, March 13, 2003 9:02 AM Subject: Re: UPDATE syntax help
> At 8:33 +1000 3/13/03, MySQL wrote: > >Hi all, I am having a little UPDATE syntax issue. According to the manual > > According to the manual, this won't work until MySQL 4.x > > > > >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