title: How to compare one table's column against another?
body: <p>I'm currently working on merging two tables and I am trying to verify if there are any duplicates across two columns. I suppose I'm looking for a Query that lats me compare every value of the columns much like: </p>
  
  <pre><code>WHERE 'column1' = 'value1' 
  </code></pre>
  
  <p>but in place of 'value1' it'd be 'column2'</p>
  
  <pre><code>WHERE 'column1' = 'column2'
  </code></pre>
  
  <p>There would also be a bit of a function to count any duplicates.</p>
  
  <p>Does anyone know if there's any function like this? So far I've drawn up blanks. </p>
  
  <p>Cheers!</p>
  
  <p>Doesn't matter - seems yesterday I made a bit problem over nothing. Thanks for getting my mind whirring. I'll Update with the result when I get some output.</p>