title: How to compare rows in two identical tables and return result set of missing rows?
body: <p>I've looked through all the related questions, but none of them does exactly what I need. I have two identically-structured tables (id, VoucherNbr, BalanceInit) - one is from our current production system (tableA), and the other is from a client's legacy system (tableB). Table A has records a,b,c,d,e (for example), and table B has a,b,c,d,e,f,g. Table B will always have all the values that exist in table A, but also has extra rows. I need to return a resultset that contains all the rows in table B that don't exist in table A (f and g, using the example.) How can I do this?</p>
  
  <p>EDIT:</p>
  
  <p>TABLE A</p>
  
  <pre><code>ID | VoucherNbr         | BalanceInit
  =============================================
  1  | 1111111111111111   | 25.00
  2  | 2222222222222222   | 50.00
  3  | 3333333333333333   | 10.00
  </code></pre>
  
  <p>TABLE B</p>
  
  <pre><code>ID | VoucherNbr         | BalanceInit
  =============================================
  15 | 1111111111111111   | 25.00
  17 | 1212121212121212   | 15.00
  22 | 2222222222222222   | 50.00
  34 | 3333333333333333   | 25.00
  41 | 3232323232323232   | 75.00
  </code></pre>
  
  <p>What I need to get back is a resultset containing only the rows that don't exist in Table A, where it's the value in the VoucherNbr field that doesn't exist, not the ID field.</p>
  
  <pre><code>ID | VoucherNbr         | BalanceInit
  =============================================
  17 | 1212121212121212   | 15.00
  41 | 3232323232323232   | 75.00
  </code></pre>