title: SQL select items from one table with conditions from another
body: <p>I have 2 Tables:</p>
  
  <pre><code>Accounts(ID, Name, Adress, Type)
  
  Holidays(Name, StartDate, EndDate)
  </code></pre>
  
  <p>And the Type column from Accounts is a  <code>SET("Manager","Director","Administrator")</code> for example.</p>
  
  <p>The Name Column for both colums are relationed. When someone creates a holiday, the Name from table Holidays will be his name from the account that is logged in.</p>
  
  <p>And i want to know if it's possible to make a SQL statement where i can take all of table 2 which the the table1.type need to be "Director" and the Table1.name needs to be on holidays.</p>