title: Comparing Table 1 with Table 2 in Netezza where Table 1 has million records
body: <p>I'm new to SQL and trying the examples but didn't find it as per my requirement. I would be happy if any pro can able to answer.</p>
  
  <p>I have a Table A with 150 columns and millions of records. I need to compare the Table A with Table B(Both Table A and B is in Netteza).  </p>
  
  <p>I need a SQL query which can compare the both tables A and B record by record and give me results if there is discrepancy in the record of Table B.</p>
  
  <h2>Table A</h2>
  
  <pre><code>FirstName LastName ZipCode
  Gary      Martin   500020
  John      Mills    788802
  </code></pre>
  
  <h2>Table B</h2>
  
  <pre><code>FirstName LastName ZipCode
  Gary      Martin   500020
  John      Mill     788802
  </code></pre>
  
  <p>Expected to get results like this:</p>
  
  <pre><code>FirstName LastName ZipCode   FirstName LastName ZipCode 
  John      Mills    788802    John      Mill     788802
  </code></pre>