title: sql SELECT IN with like
body: <p>how can i write a select query by combining IN and LIKE 
  i have a subquery which returns some records , with threse records i have to select records from another table.
  the problem is i have to use LIKE clause on the resultant recors of the subquery
  below is  an example of what im trying to do</p>
  
  <pre><code>select * from salary where employeename like (select name from employee)
  </code></pre>
  
  <p>from salary table i need records which matches the name of employe table. i need to use LIKE .
  can someone help me please</p>