Luis - Thank you so much.
I should have known that I didn't need to make the additional joins to the one-to-many relationships tables C and D.
I knew why I was getting duplicates and when you offered your solution - the light bulb went off.
Thanks again - everyone is great and helpful on this forum.
Have a great day - you earned it........