title: Join on Table valued function in select query
body: <p>I have <code>ques</code> table:</p>
  
  <p><img src="https://i.stack.imgur.com/lvL4p.png" alt="Ques table"></p>
  
  <p>and i have user defined <code>split</code> function:</p>
  
  <pre><code>Select * from split('1,2,3,4')
  </code></pre>
  
  <p>which returns data in table format by splitting string as below</p>
  
  <p><img src="https://i.stack.imgur.com/GucRL.png" alt="Data returned by Split()"></p>
  
  <p>i want to write select query on <code>ques</code> table with split function to get data like below:</p>
  
  <p><code>id |  ques | tags</code><br>
  <code>-----------------</code><br>
  <code>1  |  abc  |  1</code><br>
  <code>2  |  def  |  1</code><br>
  <code>2  |  def  |  2</code><br>
  <code>3  |  ghi  |  2</code><br>
  <code>4  |  jkl  |  3</code><br>
  <code>4  |  jkl  |  4</code>  </p>
  
  <p>Can any one help me to make this join??</p>