Request failed

Question

When I entered the code as shown below, I am returning this error:

Msg 116, Level 16, State 1, Line 1
Only one expression can be specified in the selection list if a subquery is not entered with EXISTS.

code:

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

Problem here

 E_ID NOT IN (SELECT * FROM SALARY_ADVANCE))

You must specify one column instead of all

Answer 2

The problem is in this line:

E_ID NOT IN (SELECT * FROM SALARY_ADVANCE)

You must indicate in which field you are checking this SELECT. Otherwise, you get a table, not a set of values.

E_ID NOT IN (SELECT FIELD_NAME FROM SALARY_ADVANCE)

Answer 3

NOT IN , , NULL. , , ... IS NOT NULL , .

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 E_ID 
                        FROM SALARY_ADVANCE
                      WHERE E_ID IS NOT NULL)

NOT EXISTS, .

SELECT E_ID, 
       E_NAME, 
       PROJECT, 
       MANAGER
  FROM EMPLOYEE_PROJECT INNER JOIN EMP_MASTER ON (
         EMPID = E_ID AND 
         LOCATION = 'MUMBAI' AND 
         NOT EXISTS (SELECT E_ID 
                     FROM SALARY_ADVANCE as SA
                     WHERE SA.E_ID = EMP*table*.E_ID))

Answer 4

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 E_ID 
                        FROM SALARY_ADVANCE)