IF (OBJECT_ID('tempdb..#Teste1') IS NOT NULL) DROP TABLE #Teste1
CREATE TABLE #Teste1 (
    Nome VARCHAR(100)
)

INSERT INTO #Teste1 VALUES ('Paulo'), ('João'), ('José'), ('Maria'), ('Joaquim'), ('Cleves')


IF (OBJECT_ID('tempdb..#Teste2') IS NOT NULL) DROP TABLE #Teste2
CREATE TABLE #Teste2 (
    Nome VARCHAR(100)
)

INSERT INTO #Teste2 VALUES ('Paulo'), ('João'), ('José'), ('Maria')


SELECT *
FROM #Teste1 A
LEFT JOIN #Teste2 B ON A.Nome = B.Nome
WHERE B.Nome IS NULL


SELECT *
FROM #Teste1 A
LEFT JOIN #Teste2 B ON A.Nome = B.Nome AND LEN(B.Nome) = 6
WHERE B.Nome IS NULL
AND LEN(A.Nome) = 6


SELECT *
FROM #Teste1 A
LEFT JOIN #Teste2 B ON A.Nome = B.Nome
WHERE B.Nome IS NULL
AND LEN(A.Nome) = 6