title: MySQL Add results to query based on results
body: <p>I know the title is vague and this might be hard for me to explain but this is what I am trying to accomplish.</p>
  
  <p>Say I have a table called articles.</p>
  
  <p>In that table, I have an id, password, file, group, etc....</p>
  
  <p>I want to do a query where password='thispassword'. Easy enough.</p>
  
  <p>But then join that somehow where the results of that query also include where group=file</p>
  
  <pre><code>id | password  | file   | group
  ----------------------------------
  1  | passA     | 1filea | group1
  2  | passB     | 2fileb | group1
  3  |           | group1 | 
  4  | passD     | 4filed | group2
  5  | passD     | 5filee | group2
  6  |           | group2 | 
  </code></pre>
  
  <p>With the table above if I query for passA (WHERE password='passA') it has <strong>group1</strong> in the group column. I want to also return within the same query WHERE the file equals group1 which would be id: 3 in the above table. </p>