I recommend reading Chapter 6 of Oracle Database 10g SQL or your version equivalent.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_108a.htm#2068235 -Adam On Tue, 18 Jan 2005 19:18:01 +0100, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Frank Mamone wrote: > > TABLE2 is actually the same table so I need to use an alias. Without a > > from I cannot give it an alias name. > > If TABLE1 and TABLE2 are the same table, your example: > UPDATE TABLE1 > SET TABLE1.FIELD = TABLE2.FIELD > FROM TABLE1, TABLE2 > WHERE TABLE1.KEY = TABLE2.KEY > AND TABLE1.FIELD = 'Y' > > simplifies to a no-op: > UPDATE TABLE1 > SET FIELD = FIELD > WHERE FIELD = 'Y' > > which is probably not what you want. > > How about giving us the real schema? > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190957 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