title: Column does not exist in the IN clause, but SQL runs
body: <p>I have a query that uses the <code>IN</code> clause.  Here's a simplified version:</p>
  
  <pre><code>SELECT *
    FROM table A
    JOIN table B
      ON A.ID = B.ID
   WHERE B.AnotherColumn IN (SELECT Column FROM tableC WHERE ID = 1)
  </code></pre>
  
  <p><code>tableC</code> doesn't have a <code>Column</code> column, but the query executes just fine with no error message.  Can anyone explain why?</p>