title: UPDATE one table based on values in another table
body: <p>I have two tables, Table 1 has three fields (a1,a2,a3) and table 2 has three fields (b1,b2,b3) I want to update table one base on table two when a1=b1 . This is essay in Microsoft access but I want t to do it in Microsoft Access project Sql server 2005 as a back end.</p>
  
  <pre><code>UPDATE  t1
  SET  a1 = t2.b1, a2 = t2.b2, a3 = t2.b3
  where a1=b1
  </code></pre>