I tried your query but it came out like this. The 3rd row is not correct.

TNID TNMIN TNMAX

3011170 44027871004402787103

3011171 44027871044402787105

3011175 44027871184409447976

here's the missing recs:

TNID TN1 TN2

3011175 4402787118 4402787119

3011175 4405165555 4405165558

3011175 4409447976 4409447976

Thanks for trying :-). Anyone out there have other ideas.