title: SQL SELECT multiple Lines where one line is like, MSSQL
body: <p>Following Setup:</p>
  
  <p>t1</p>
  
  <pre><code>ID     Name      Price
  1      Miller    50      
  2      Smith     10
  3      Someone   20
  </code></pre>
  
  <p>t2</p>
  
  <pre><code>ID    Item    Price
  1     10.1    25
  1     10.2    25
  2     32.1    10
  3     32.1    10
  3     11.1    2
  3     12.2    3
  3     43.2    5
  </code></pre>
  
  <p>What I have to do, is to select all entries from the 2nd Table where one is like 11.1. I'm using this query:</p>
  
  <pre><code>SELECT
  t1.ID
  t1.Name
  t2.Item
  
  FROM t1 
  JOIN t2 on t1.ID = t2.ID
  WHERE t2.item in ('11.1)
  </code></pre>
  
  <p>I should get the following result:</p>
  
  <pre><code>ID     Name    Item
  3      Someone 31.1
  3      Someone 11.1
  3      Someone 12.2
  3      Someone 43.2
  </code></pre>
  
  <p>but because I do a "where" on a specific item I only get one line. How can I get all the lines from t2 when only 1 line is matching the "11.1"?</p>