<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Mar 2, 2012, at 5:58 PM, George Parkinson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'lucida console', sans-serif; font-size: 10pt; position: static; z-index: auto; "><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></div></blockquote><br></div><div>update t1 set t1.f1 = (select t2.f1 from t2 where t1.id = t2.id)</div><div><br></div><br><div apple-content-edited="true">
<div>-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div>
</div>
<br></body></html>