join tables on UPDATE

m) = 'san juan'; i get an error ERROR 1064 at line 1: You have an error in your SQL syntax near 'left join trans ferdetails on transfer.docno = transferdetails.docno set transfer' at line 1 im using mysql 3.23.41 on win32 TIA johnhomer ___

Re: RE: join tables on UPDATE

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: