title: How to call table valued function inside select Statement?
body: <p>I have created table valued function.
  I am calling like this </p>
  
  <pre><code>select * from dbo.fun_sample(1)
  </code></pre>
  
  <p>It is working fine. I have table called Emp</p>
  
  <pre><code>Table Emp
  
  Id Name Lname
  1  Rani Kale
  </code></pre>
  
  <p>My select Statement is like this</p>
  
  <pre><code>Select id,Name,Lname from Emp
  </code></pre>
  
  <p>By passing value of id to function ,I want fetch table(having 2 column).But is not working</p>
  
  <pre><code>Select id,Name,Lname,(select * from dbo.fun_sample(1)) from Emp
  </code></pre>