Distinct does not do anything. Distinct returns only one row for duplicate rows. Since XXX YYY 101 is different from YYY XXX 101, it wount eliminate one or the other.

>Why You not try DISTINCT clause of SELECT ?