title: Inner join in Insert query?
body: <p>I wanna do something like this:</p>
  
  <pre><code>insert into TableA 
     (val1,val2) 
  values
     ("value",(select top 1 tableB.X from tableB where tableB.Y=@Y))
  </code></pre>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>Subqueries are not allowed in this context. Only scalar expressions are allowed</p>
  </blockquote>
  
  <p>How to stop that error?</p>