title: Table join with scalar valued function
body: <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>