title: SQL query to get specific rows based on one value
body: <pre><code>ID        Place          Name                Type              Count
  --------------------------------------------------------------------------------
  7718    | UK1   |  Lemuis           | ERIS TELECOM          | 0
  7713    | UK1   |  Astika LLC       | VERIDIAN              | 34
  7712    | UK1   |  Angel Telecom AG | VIACLOUD              | 34
  7710    | UK1   |  DDC S.r.L        | ALPHA UK              | 25
  7718    | UK1   |  Customers        | WERTS                 | 0
  </code></pre>
  
  <p>Basically I have a variable and I want to compare that variable the the <code>'Type'</code> column. If the variable matches the type then I want to return all the rows that have the same ID as the variable's ID.</p>
  
  <p>For example, my variable is <code>'ERIS TELECOM'</code>, I need to retrieve the ID for <code>'ERIS TELECOM'</code> which is <code>7718</code>. Then I search the table for rows that have the <code>ID 7718</code>.</p>
  
  <p>My desired output should be:</p>
  
  <p>Table Name: <code>FullResults</code></p>
  
  <pre><code>ID        Place          Name                Type              Count
  --------------------------------------------------------------------------------
  7718    | UK1   |  Lemuis           | ERIS TELECOM          | 0
  7718    | UK1   |  Customers        | WERTS                 | 0
  </code></pre>
  
  <p>Is there a query that will do this?</p>