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;
- Re: update from another table Jim Gillaspy @ bellsouth.net
- Re: update from another table Sinisa Milivojevic