title: INSERT INTO using WHERE
body: <p>I'm trying to insert the <code>JobNo</code> and <code>CellNo</code> columns that are not in <code>Table_1</code> from <code>View_1</code>. I wrote this query &amp; I get an error. </p>
  
  <p>Please help me out in correcting this.</p>
  
  <p>I'm using SQL Server 2008</p>
  
  <pre><code>INSERT INTO Table_1(ID, JobNo, CellNo)
     SELECT View_1.ID, View_1.JobNo, View_1.CellNo
     FROM View_1
     WHERE View_1.JobNo 
     AND View_1.CellNo NOT IN (SELECT JobNo, CellNo FROM Table_1)
  </code></pre>