Web Listing 6: JOIN Query Returning Undesired Results
SELECT DISTINCT C.Country, C.Region, C.City
FROM dbo.Customers AS C
  JOIN dbo.Employees AS E
    ON C.Country = E.Country
    AND C.Region = E.Region
    AND C.City = E.City;