title: How do I make a query listing certain elements of a column that are in a subquery table, SQL. EXISTS, IN?
body: <p>I'll just show you guys an example: I got these tables:</p>
  
  <p>Table: Car Mark</p>
  
  <pre><code>Name | Manufacturer
  ------------------- 
  POLO   VOLKSWAGEN  
  A6     AUDI
  911    PORSCHE
  </code></pre>
  
  <p>Then I get this sub table, from about three tables, from a subquery:</p>
  
  <pre><code>Manufacturer |  Num of rented cars, by clients age &gt; 50
  -------------------------------------------------------
  VOLKSWAGEN                      2 
  AUDI                            3
  </code></pre>
  
  <p>My question is: how do I select the manufacturer from <code>Car Mark</code> that exist in this subquery?</p>
  
  <p>I just want an output:</p>
  
  <pre><code>Manufacturer
  ---------------
  VOLKSWAGEN
  AUDI 
  </code></pre>