title: SQL Query With Multiple Sub-queries
body: <p>Building a Tag Based internal phone book and have created a linking table, but can't see how to join a select all people who are a manager and director from Aberdeen and Manchester.</p>
  
  <p>Users</p>
  
  <pre><code>ID | Name | etc
  1 | Frank
  2 | Bob
  3 | Bert
  </code></pre>
  
  <p>Tags</p>
  
  <pre><code>ID | TagName | Tag Order
  1 | Aberdeen | 1
  2 | Manchester | 1
  3 | Staff | 2
  4 | Manager | 2
  5 | Director | 2
  </code></pre>
  
  <p>Linking Table</p>
  
  <pre><code>ID | UsersId | TagsId
  1 | 1 | 1
  2 | 2 | 1
  3 | 3 | 2
  </code></pre>
  
  <p>If tag Aberdeen is selected it will show Frank and Bob
  If tag Manchester is selected it will show Bert
  I want to select Tag Aberdeen and Tag Manchester to show everyone
  Then I want to select all people who are a manager and director from Aberdeen and Manchester.</p>
  
  <p>Trying to work out the SQL is a struggle, any ideas, thanks in advance.</p>