Thanks, guys.

I was able to solve my own problem of weeding out the dupes by rewriting a subquery.

I had used a table alias in a subquery that was already in use in the main query and the subquery couldn't do its job properly. Once I renamed the alias in the subquery I now get exactly what I expect to see.

Thanks again for being willing to pitch in!