title: Comparing values of 2 tables and listing the rows that are different
body: <p>This question is in the same vein as <a href="https://stackoverflow.com/questions/4602083/sql-compare-data-from-two-tables/4604221#comment-7562192">this question</a>, but just slightly different.</p>
  
  <p>I have 2 tables, TableA and TableB where TableB is really just a backup of TableA, the only real difference is that TableB has an "ACTION" column that indicates the action that had been taken in TableA. For now I am ignoring that column (although ideally I would want it appended to the final results, so please feel free to suggest on that too :D )</p>
  
  <p>I want to compare the two tables and get the rows from each table that are different. I've used <a href="http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx" rel="nofollow noreferrer">Jeff's SQL Server Blog - The shortest, fastest, and easiest way to compare two tables in SQL Server: UNION !</a> example to create a query, however, it returns only the rows from TableB that are different. </p>
  
  <p>What is the recommended approach?</p>
  
  <p><em>Note: the code is exactly like the example in the second link, so I won't post any of it here</em></p>