title: WHERE EXISTS not working
body: <p>I know I can do this with a table join, however, I'm trying to do it with a WHERE EXISTS clause. I know there are 65 matches, nonetheless, the sub query is not working. It brings all the values from table scrubs. </p>
  
  <p>pdwspend.<code>Child Supplier ID</code> has many duplicates values that why I use DISTINCT in the sub query.</p>
  
  <pre><code>SELECT DISTINCT sc.`BW Parent Number`
  FROM scrubs sc
  WHERE EXISTS (
  
      SELECT DISTINCT pdwspend.`Child Supplier ID`
      FROM pdwspend
      WHERE pdwspend.`BU ID` = 'BU_1'
      AND pdwspend.version LIKE '%GOV%'
      )
  AND SC.`year` =2014
  </code></pre>
  
  <p>Thanks</p>