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...

Reply via email to