title: MySQL - working with SELECT - newbie
body: <p>absolute newbie here:</p>
  
  <p>I have table with columns: resource, resource_type_field, value. 
  I have this simple query</p>
  
  <pre><code>SELECT `resource` FROM `resource_data` WHERE `resource_type_field`=8
  </code></pre>
  
  <p>and would need to take the results, do another query on these results:</p>
  
  <pre><code>SELECT `resource` FROM `resource_data` WHERE `value`=2011
  </code></pre>
  
  <p>and than select 'value', where these two queries matches. How is this done?</p>
  
  <p>Thanks for help.</p>