Table join with scalar valued function
<p>I am trying to apply a join between a table and a scalar-valued function. I have been investigating and I think that it is not possible, but as I do not find any final conclusion saying that I want to be sure.</p>

<p>Do you know if it is possible?</p>

<p>I tried the following statement (do not work):</p>

<pre><code>Select * 
from T1
join SVFunction on T1.id=SVFunction.id
</code></pre>

<p>And also this one (do not work):</p>

<pre><code>Select * 
from T1
outer apply SVFunction (T1.id)
</code></pre>

<p>Thank you.</p>