@Azadi and Leigh, the oracle syntax gives this on mysql: Error Code: 1093 You can't specify target table 'dfv1' for update in FROM clause.
Ended up with this for mysql: UPDATE MyTable t1 LEFT OUTER JOIN t2 ON t2.SomeColumn = t1.SomeColumn AND t2.SomeOtherColumn = t1.SomeOtherColumn AND t2.YetAnotherColumn = 42 SET Foo = 1 WHERE Bar = 99 AND t2.SomeColumn IS NULL Funky stuff. Dave On Mon, Nov 1, 2010 at 10:14 AM, Leigh <cfsearch...@yahoo.com> wrote: > >> This more straight ahead version also works for Oracle: > > What error are you getting? I would expect that syntax to work with MySQL 5. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm