title: T-SQL inner query like join based off IN results
body: <p>I have a T-SQL query that has a subquery listing 2 names:</p>
  <ul>
  <li>Coop</li>
  <li>Bro</li>
  </ul>
  <p>Code:</p>
  <pre><code>Select LastName 
  From Managers 
  Where Type = prefix;
  </code></pre>
  <p>I need to have the outer query use this above sub-query in something like an 'IN' statement, but it's not an exact match, but rather a BEGINS WITH.  Something like the following with + '%':</p>
  <pre><code>Select *
  From Employees
  Where LastName In (Select LastName + '%'
                     From Managers
                     Where Type = prefix)
  </code></pre>
  <p>Desired query would return back outer query results such as:</p>
  <ul>
  <li>Cooper</li>
  <li>Coopersmith</li>
  <li>Coopmoth</li>
  <li>Brown</li>
  <li>Brownly</li>
  <li>Bronnan</li>
  </ul>
  <p>...but, this is not working.  I get 0 results.</p>