How to filter extra lines?

Question

SQL Server

There are documents that have Node with information. With this kind of request, it really shows the name and Node. (since there cannot be more than one Node with this name in the document)

SELECT DocumentTemplateName, DocumentTemplateNodeCaption
from DocumentTemplate join 
DocumentTemplateVersion on DocumentTemplateRef = DocumentTemplateID
join DocumentTemplateNode on DocumentTemplateVersionID = DocumentTemplateVersionRef 
where DocumentTemplateNodeName ='CodeName'

But it is required to find documents in which there is no such Node.

SELECT DocumentTemplateName, DocumentTemplateNodeCaption
from DocumentTemplate join 
DocumentTemplateVersion on DocumentTemplateRef = DocumentTemplateID
join DocumentTemplateNode on DocumentTemplateVersionID = DocumentTemplateVersionRef 
where DocumentTemplateNodeName !='CodeName'

As a result, we have a lot of records, where one document shows 500 Node. - 500 lines in which DocumentTemplateName is repeated Tell me how to edit?