sql - 无法执行查询

Question

当我输入如下所示的代码时，我收到此错误:

Msg 116, Level 16, State 1, Line 1
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

代码:

SELECT 
    E_ID, E_NAME, PROJECT, MANAGER
FROM 
    EMPLOYEE_PROJECT 
INNER JOIN 
    EMP_MASTER ON (EMPID = E_ID AND LOCATION = 'MUMBAI' AND 
                   E_ID NOT IN (SELECT * FROM SALARY_ADVANCE))

Answer 1

问题就在这里

 E_ID NOT IN (SELECT * FROM SALARY_ADVANCE))

您必须提及一列而不是全部