SQL 错误 - 列数多于列列表中指定的列数

Question

我正在尝试从以下查询中检索结果，但不断收到此错误消息:

Msg 8158, Level 16, State 1, Line 1
'a' has more columns than were specified in the column list.

我的查询:

select
    * 
from 
    (select 
         customer_key as customer_id, updated_by as [Help Desk] 
     from 
         permission) a (nolock)
where 
    [Help Desk] is not null

Answer 1

select 
    * 
from 
    (select 
         customer_key as customer_id, updated_by as [Help Desk] 
     from 
         permission with (nolock)) as a