title: Get list of parent and child records with multiple entries with criteria - SQL 2005
body: <p>I have parent / child tables:</p>
  
  <p>parent table:</p>
  
  <h2>id | description</h2>
  
  <p>1  | Alexandra
  2  | Natalia</p>
  
  <p>child table:</p>
  
  <h2>id | id_parent | description</h2>
  
  <p>1  |     1     | Programmer
  2  |     1     | Surgery
  3  |     2     | Programmer
  4  |     2     | IT</p>
  
  <p>How to return set of record according filters, like if we want to get all records with "Programmer" we would like to have set:</p>
  
  <p>response table:</p>
  
  <h2>id_parent | id_child | description (from child)</h2>
  
  <pre><code>1     |    1     |  Programmer
  2     |    3     |  Programmer
  </code></pre>
  
  <p>BUT if filter looks like: "Programmer" AND "Surgery", query MUST return only:</p>
  
  <p>response table:</p>
  
  <h2>id_parent | id_child | description (from child)</h2>
  
  <pre><code>1     |    1     |  Programmer
  1     |    2     |  Surgery
  </code></pre>
  
  <p>As you can see I also need some kind of "join" in order to "connect" description and code in child table.</p>
  
  <p>Thanks in advance.</p>