The following example is from the chapter on advanced query techniques. My question: does it make any difference whether you specify "distinct" in the subquery? I sometimes use it and sometimes don't, for no particular reason. Trivial, maybe, but a matter of curiosity. Thanks.
Code:
USE AdventureWorks
SELECT e.EmployeeID, FirstName, LastName
FROM HumanResources.Employee e
JOIN Person.Contact c
ON e.ContactID = c.ContactID
WHERE e.EmployeeID NOT IN
(SELECT DISTINCT EmployeeID
FROM HumanResources.JobCandidate
WHERE EmployeeID IS NOT NULL)
Rookie question about "Professional" book
Linear Mode
