Hello all this should be simple... maybe i'm getting old. T1 has fields ID,NAME,OLDNAME T2 has fields ID,NAME ID is primary key in both tables. all IDs in T2 are already present in T1 I need a query that updates T1.OLDNAME to the value of T1.NAME AND T1.NAME to T2.NAME for corresponding IDs. This is how I do it in ms sql server, (I know this sintax is not valid in oracle, its just to make it clear): UPDATE T1 SET T1.OLDNAME=T1.NAME,T1.NAME=T2.NAME FROM T1 INNER JOIN T2 ON T1.ID=T2.ID; T1 contains about 130,000 records, T2 contains about 27,000. DB is oracle 10g Any help will be greatly appreciated.