executing table valued valued function in select statement
<p>I have a table valued function with one parameter </p>

<p>mytabfunct(@para nvarchar(20))</p>

<p>this function returns 4 values.</p>

<p>Now I have a table named Employee and I am running a query like this: </p>

<pre><code>select
Fname, Lname,
(select
 * from mytabfunct
 ('joseph'))
from  Employee where
Fname='joseph';
</code></pre>

<p>but it is giving me the error:</p>

<pre><code>Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
</code></pre>

<p>I checked for the Error and on some of the forum I found that the error is bcz my function is returning multiple records. But how can I get all those 4 values with the other values like Fname, Lname etc in Employee tbale.</p>

<p>what is wrong here , I am not able to fix.</p>