title: Mismatch data in Columns
body: <p>I`m a newbie to SQL world, Can someone help me out with this.</p>
  
  <p>I have two tables with same columns, CID, Amount. Both have a different logic on how the data is inserted but technically both tables should have same amount of CID's in count.</p>
  
  <p>In my case I do have same count for given period, however I believe the Amount is a mismatched. </p>
  
  <p>I want to identify which CID`s have wrong Amount and escalate this issue to Level 4 to see the business logic.</p>
  
  <p>Can someone show me how can I find the mismatched?</p>
  
  <p>When I did:</p>
  
  <pre><code>select count(CID) from Table A
  union all 
  select count(CID) from table B
  </code></pre>
  
  <p>I get 1000 on both select.</p>