I am having trouble doing an update with a join in Oracle. I am getting this error:
SQL command not properly ended. Here is the generic syntax I am using: UPDATE TABLE1 SET TABLE1.FIELD = TABLE2.FIELD FROM TABLE1, TABLE2 WHERE TABLE1.KEY = TABLE2.KEY AND TABLE1.FIELD = 'Y' Thanks for your help. Frank ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190837 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
