MYSQL IN替代

Question

美好的一天

我正在尝试查询从事每个项目的员工的姓名。我的代码如下:

SELECT CONCAT (fname,' ', minit,'. ' , lname) AS NAME
FROM employee a, works_on b, project c
WHERE pno IN (Select pnumber      //WHAT COULD I SUBSTITUTE W/ IN
              FROM projet) 
     AND a.ssn = b.essn
     AND b.pno = c.pnumber 

IN 的问题在于，它内部的值就像被评估为“OR”...什么是 IN 的等价物，它使我的子查询的值被评估为“AND”

提前谢谢你。

编辑:根据要求..

Answer 1

SELECT  *
FROM    employee e
WHERE   NOT EXISTS
        (
        SELECT  NULL
        FROM    employee ei
        CROSS JOIN
                project p
        LEFT JOIN
                works_on wo
        ON      wo.pno = p.pnumber
                AND wo.essn = ei.ssn
        WHERE   ei.ssn = e.ssn
        )