title: Insert all rows from one table into another that dont have a similar value?
body: <p>I have two tables. One master and one smaller. I just want to insert all of the rows from the smaller into the master that do not have the same value in a certain field. What I have tried is not working.  Also is there a way I can specify all values in row and not list them out individually?</p>
  
  <p>Something like...</p>
  
  <pre><code>Update Master
  Set Master.[All Values] = Smaller.[All Values]
  Inner join Smaller on Master.No = Smaller.No
  where Master.No &lt;&gt; Smaller.No 
  </code></pre>