On: Don't use DISTINCT as a "join-fixer"

[croes]

You could CROSS APPLY or OUTER APPLY with the Top (1) of a subquery to get exactly one value per customer per row.