update join

[George Parkinson]

hello all,
i'm trying to do a mass update of a field in a table with the value of a similar field from another table, based on a common id.

ie:
UPDATE t1 
SET t1.f1 = t2.f1 
FROM t1 
JOIN t2 ON t1.id = t2.id  

but this results in an error:
Kernel error: 0x71000. line 2:7: expecting '=', found '.'


i've tried other variations but am obviously missing something (probably simple)
anyone have a suggestion?

thanks,
george
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120302/f09cf97d/attachment.html>