Re: Update error on ver 3.23, works on ver 5.0

2007-08-02 Thread Tim Johnson
On Thursday 02 August 2007, Tim Johnson wrote: > Hi: > I use 5.0.38 on my ubuntu desktop > and I have to work with ver 3.23.56 on a solaris-based server. > > The following update query: > UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE > wine_list.wine_ID=FRED.wine_ID; > > works on 5.

Re: Update error on ver 3.23, works on ver 5.0

2007-08-02 Thread Baron Schwartz
Hi, Tim Johnson wrote: Hi: I use 5.0.38 on my ubuntu desktop and I have to work with ver 3.23.56 on a solaris-based server. The following update query: UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE wine_list.wine_ID=FRED.wine_ID; works on 5.038, but on 3.23.56 I get the follo