Ah yes, good point Jeff!
I've seen plenty of DISTINCT code that had some dodgy JOINs, or bad assumptions about the underlying data relationships.
I was only hazarding a guess with the "delete your temp tables after processing"...
(as a side note, your articles are amazing! Keep up the writing and the propagation of set-based thinking! 😀 )