Registros que no estan en otro tabla

[artcevise]

OBTUVE ESTA CONSULTA, PERO SI TIENEN ALGO MAS OPTIMO POR FAVOR DIGANME COMO


SELECT DOM.Id_dominio, COUNT(DOM.id_dominio) suma
FROM eMailF_Dominios AS DOM
INNER JOIN eMailF_Leidos_Unicos AS LU ON DOM.id_dominio = LU.id_dominio
WHERE DOM.id_dominio NOT IN
(
SELECT DOM.id_dominio
FROM eMailF_Dominios AS DOM
INNER JOIN eMailF_Leidos_Unicos AS LU ON LU.id_dominio = DOM.id_dominio
INNER JOIN eMailF_FechasLectura AS FL ON FL.id_leido_unico = LU.id_leido_unico
GROUP BY DOM.id_dominio
)
GROUP BY DOM.id_dominio
ORDER BY (COUNT(DOM.id_dominio))DESC