title: SQL Error - has more columns than were specified in the column list
body: <p>I'm trying to retrieve results from the below query but keep getting this error message:</p>
  
  <blockquote>
    <p>Msg 8158, Level 16, State 1, Line 1<br>
    'a' has more columns than were specified in the column list.</p>
  </blockquote>
  
  <p>My query:</p>
  
  <pre><code>select
      * 
  from 
      (select 
           customer_key as customer_id, updated_by as [Help Desk] 
       from 
           permission) a (nolock)
  where 
      [Help Desk] is not null
  </code></pre>