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:338720
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
