title: Comparing two views
body: <p>I current have two views that are pulling in different results. 
  One is in the old database and the other is in the new.<br>
  the ond view pulls in ~50000 records whereas the new view is pulling in ~40000<br>
  Both have almost all the same data except for one or two columns.</p>
  
  <p>Is there a way where I can combine the two and see what is different?</p>
  
  <p>I have limit knowledge when it comes to queries and joins.  </p>
  
  <p>I tried left joining and right joining but it is giving me 100000+ results.  I dont want that.  I want ~50000 results and have the columns null where there is no info.</p>
  
  <p>Is this possible? thanks</p>