If you have duplicates in the key fields used for the right side of join, then there will be one copy for each of those duplicate values in the result.Here you have duplicates in both Partmaster and PDMCTA (of the fields used as the key for the join.
A SQL left join has the same behaviour.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein