ayuda con consulta select basica

[jurena]

Código MySQL:

SELECT DISTINCT orderno FROM purchorderdetails WHERE completed = 1 AND orderno NOT IN (SELECT orderno FROM purchorderdetails WHERE completed != 1)