SQL Error - has more columns than were specified in the column list
<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>