不显示给定条件的任何记录(SQL)

我认为,如果在加入客户的条件下,您排除了那里的客户名称,它将返回您想要的内容,那么它应该会起作用。

SELECT consultant.name, consultant.surname 
FROM consultor
INNER JOIN participate ON participate.id_consultant = consultant.id
INNER JOIN project ON  project.id = participate.id_project
INNER JOIN client ON  client.id = project.id_client and client.name NOT IN ("Juan Perez");

我用下面的方法解决了这个问题。谢谢大家的帮助。

SELECT consultant.name, consultant.surname FROM consultant 
LEFT JOIN (
           SELECT id_project, participate.id_consultant FROM participate 
           INNER JOIN project 
           USING(id_project) 
           INNER JOIN client ON client.id = project.id_cliente 
                 WHERE client.name like 'Juan Perez'
          )
project ON project.id_consultant = consultant.id 
        WHERE project.id_project IS NULL;