Dennis, That seems to be the correct syntax... very cool.. many thanks!!! --Francisco
On 4/5/06, Dennis Cote <[EMAIL PROTECTED]> wrote: > Francisco Tapia wrote: > > >I want to update data from table1 to table2, i seems I cannot get this > >to work right, perhaps my syntax is wrong? > > > > > >update table1 > >set table1.f1 = table2.f1 > >FROM table1, table2 > >WHERE table1.f0 = table2.f0 > > > > > >-- > >-Francisco > >http://pcthis.blogspot.com |PC news with out the jargon! > >http://sqlthis.blogspot.com | Tsql and More... > > > > > > > Francisco, > > Try this instead. > > update table1 > set f1 = (select f1 from table2 where table2.f0 = table1.f0) > > HTH > Dennis Cote >
