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