Re: update from another table

Jim Gillaspy @ bellsouth.net writes: > I've looked for two hours on www.mysql.com and can't find how to do what would be >the following in Oracle: > > Update tablea set (a,b,c) = (select d,e,f from tableb) > where a=y; > > Hi! For the moment you will have to use temporary tables. B

update from another table

I've looked for two hours on www.mysql.com and can't find how to do what would be the following in Oracle: Update tablea set (a,b,c) = (select d,e,f from tableb) where a=y;