title: SQL Server select within select invalid column name
body: <p>I am using SQL Server. I have the following query:</p>
  
  <pre><code>select 
      convert(varchar(10), MAX(closedate), 101) 
  from 
      (select PSer.Signin_Date as closedate 
       from PSer 
       where ID = '12')
  </code></pre>
  
  <p>Note that the content within my from is more complicated than the simplified version I have.</p>
  
  <p>I get a message saying </p>
  
  <blockquote>
    <p>Invalid column name closedate</p>
  </blockquote>