title: MS-SQL In statement
body: <pre><code>Select a, b, c from table where a in (1, 2, 3)
  </code></pre>
  
  <p>What if the list is in a column?</p>
  
  <p>I try this will error:</p>
  
  <pre><code>Select a, b, c from a in b
  </code></pre>
  
  <p>Sorry for not clear my question.</p>
  
  <p>It's not about <strong>join</strong> or <strong>in (select b from table)</strong></p>
  
  <p>Column b type is nvarchar, data is a list, like this '1,2,5'</p>
  
  <p>Column a type is int.</p>