how to join datasets?

I have 2 tables that I would like to join on a property name called "new_name". One of the table is in cache. I expected a few records to join together based on having the same new_name values. But, none of the records join together. I have trim the new_name property to make sure no extra spaces before and after the value. Will appreciate any help!