Problema com Query

[gremio10 14]

Fala galera, não sei o que aconteceu com minha query,

 

assim ela funciona :

SELECT  `service_client`.* FROM `service_client`  LEFT JOIN `service_client_answer` ON (service_client.id = service_client_answer.service_client_id) WHERE  (NOT IN (SELECT service_client_answer.service_client_id FROM service_client_answer))

 

agora, assim :

SELECT  `service_client`.* FROM `service_client`  LEFT JOIN `service_client_answer` ON (service_client.id = service_client_answer.service_client_id) WHERE  (service_client.service_type_id = 3 AND NOT IN (SELECT service_client_answer.service_client_id FROM service_client_answer))

não vai, POR QUE ?!

 

Obrigado.

[Wess 1]

gremio10, no seu segundo SQL você tem que identificar qual campo não pode ser igual aos valores retornado pela subquery.

SELECT  
   `service_client`.* 
FROM 
   `service_client`  
       LEFT JOIN `service_client_answer` ON (service_client.id = service_client_answer.service_client_id) 
WHERE  
   (service_client.service_type_id = 3 AND 
    service_client.service_type_id NOT IN (SELECT service_client_answer.service_client_id FROM service_client_answer))