Hello, Is there a way to keep all of the rows of an input file, even if they don't meet the Where condition? Example: Input File: Customer ID 123 456 789 Need: Customer ID Assigned Team Member 123 456 Jane Doe 789 Here is what I have so far, but of course it is only returning the row that meets the Where clause. SELECT DISTINCT
t1.CustomerID
t2.AssignedTeamMember
FROM WORK.Input t1
LEFT JOIN Team.Names t2 ON (t1.Customer_ID = t2.CustomerID)
WHERE t2.AssignedTeamMember NOT IS MISSING
... View more