• with the A,B,C,D,E example, the select distinct syntax would be better imho.