Removed duplicates from a join.