Have you tried throwing a rank on the table that’s causing the duplicates. Then join on that table to with  rank = 1 so you are only getting 1 recorded...