title: Query to match different values in one column that have same value in a separate column
body: <p>I am trying to write a query that will take two different values in column b and then compare it with column c to determine if the two values in column b share the same value in Column C. However i also need column A in the output as well.  </p>
  
  <p>For example</p>
  
  <pre><code>Column A         Column B        Column C
  Test 1           x               12345
  Test 2           y               12345
  Test 3`          A               12344
  Test 4           D               12342
  </code></pre>
  
  <p>Desired Output</p>
  
  <pre><code>Column A        Column B        Column C
  Test 1           x              12345
  Test 2           y              12345
  </code></pre>
  
  <p>Any help would be great</p>