title: sql insert rows from another table based on condition
body: <p>Consider the following two tables</p>
  
  <p>Table 1</p>
  
  <pre>
  ID    DATA
  1      'A'
  2      'B'
  3      'C'
  4      'D'
  5      'E'
  6      'F'
  </pre>    
  
  <p>Table 2</p>
  
  <pre>
  ID    DATA
  2       'G'
  3       'F'
  4       'Q'
  </pre>
  
  <p>How do I insert data into Table 1 from Table 2 where Table 2 doesn't have Table 1's ID?</p>
  
  <p>In other words, I'd like the following result:</p>
  
  <p>Table 2</p>
  
  <pre>
  ID    DATA
  1       'A'
  2       'G'
  3       'F'
  4       'Q'
  5       'E'
  6       'F'
  </pre>