very cool. thanks. On 4/5/06, Dennis Cote <[EMAIL PROTECTED]> wrote: > Francisco, > > You might want to add a coalesce() call so the f1 value is only changed > if there is a corresponding value in table2. > > update table1 > set f1 = coalesce((select f1 from table2 where table2.f0 = table1.f0), f1) > > Dennis Cote >
-- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...