Yes, the actual query's different, that's why the msg about 'dfv1', which wasn't actually in the version I posted.
Anyway, I'm good I think, thanks for checking. Dave On Mon, Nov 1, 2010 at 11:42 AM, Leigh <cfsearch...@yahoo.com> wrote: > > Yes, putting the JOIN in the UPDATE should work for MySQL. > >> 1093 You can't specify target table 'dfv1' for update in >> FROM clause. > > Though I am thinking the actual query was different than what you posted. > Because I tried version #3 with MySQL 5 and it _seemed_ to run without error. > Anyway, glad you have something that works now. > > -Leigh > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm