<html><body><div style="color:#000; background-color:#fff; font-family:lucida console, sans-serif;font-size:10pt"><div><div><font face="'lucida console', sans-serif" size="2">hello all,</font></div><div><font face="'lucida console', sans-serif" size="2">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.</font></div><div><font face="'lucida console', sans-serif" size="2"><br></font></div><div><font face="'lucida console', sans-serif" size="2">ie:</font></div><div><font face="'lucida console', sans-serif" size="2">UPDATE t1 </font></div><div><font face="'lucida console', sans-serif" size="2">SET t1.f1 = t2.f1 </font></div><div><font face="'lucida console', sans-serif" size="2">FROM t1 </font></div><div><font face="'lucida console', sans-serif" size="2">JOIN t2 ON t1.id = t2.id </font></div><div style="font-family: 'lucida console', sans-serif; font-size:
10pt; "><br></div><div style="font-family: 'lucida console', sans-serif; font-size: 10pt; ">but this results in an error:</div><div><font face="'lucida console', sans-serif" size="2">Kernel error: 0x71000. line 2:7: expecting '=', found '.'</font><br></div><div><font face="'lucida console', sans-serif" size="2"><br></font></div><div><font face="'lucida console', sans-serif" size="2">i've tried other variations but am obviously missing something (probably simple)</font></div><div><font face="'lucida console', sans-serif" size="2">anyone have a suggestion?</font></div><div><font face="'lucida console', sans-serif" size="2"><br></font></div><div><font face="'lucida console', sans-serif" size="2">thanks,</font></div><div><font face="'lucida console', sans-serif" size="2">george</font></div><div><font face="'lucida console', sans-serif" size="2"><br></font></div><div style="font-family: 'lucida console', sans-serif; font-size: 10pt;
"><br></div></div></div></body></html>