thank you
Steve Meyers wrote: >That will be in some release of either 4.0 or 4.1, I'm not sure which. >=20 >Steve Meyers > > >> -----Original Message----- >> From: JohnHomer [mailto:[EMAIL PROTECTED]] >> Sent: Friday, October 19, 2001 2:11 AM >> To: [EMAIL PROTECTED] >> Subject: join tables on UPDATE >>=20 >>=20 >> hi list, >>=20 >> can mysql allow table joins when using UPDATE query? like >>=20 >> update tranfer left join transferdetails >> on transfer.docno =3D transferdetails.docno >> set transferdetails.docno =3D concat('SJ',transferdetails.DocNo) >> where >> transferdetails.docno not regexp '^SJ' and >> lower(xfrom) =3D 'san juan'; >>=20 >>=20 >> i get an error=20 >>=20 >>=20 >> ERROR 1064 at line 1: You have an error in your SQL syntax near=20 >> 'left join trans ferdetails on transfer.docno =3D=20 >> transferdetails.docno set transfer' at line 1 >>=20 >> im using mysql 3.23.41 on win32 >>=20 >>=20 >> TIA >>=20 >> johnhomer >>=20 >>=20 >>=20 >> __________________________________ >> www.edsamail.com >>=20 >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >>=20 >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail=20 >> = ><[EMAIL PROTECTED]= >> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >>=20 >>=20 > > > >--------------------------------------------------------------------- >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 > > > __________________________________ www.edsamail.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
