select
Elm_EmployeeId as 'Badge',
Left(T_EmployeeLeave , Len(T_EmployeeLeave) - 1) As 'a'
from
(select
E2.Elm_EmployeeId as 'Badge2',
(select Elm_EmployeeId
from T_EmployeeLeave E1)
from
T_EmployeeLeave E2)
错误是:
Msg 102,级别 15,状态 1,第 8
行 ")"附近的语法不正确。
1.您从子查询中选择Elm_EmployeeId和T_EmployeeLeave,但在子查询中您没有这两列,您拥有的是徽章2和non_named列
- 从 E1 中选择T_EmployeeLeave Elm_EmployeeId毫无意义
- 查询很悲惨,我什至无法说出您到底想要什么