left data set has 96 records, right data set has 178 records - used join tool to join by specific fields and the final output came out with some duplicate lines, was expecting 96 records from left data set with new additional fields as result of join but duplicate records have been generated! what it could be .. been using join on other occasions and it worked well but no idea what's the gap here? can you please help
