>Hi,
>
>The results should be :
>
>We did not know the first name is JOE, JAY or JAR, JAN, JIL, JUL.....
>
>The six ID below are different and must be show up in the results of SQL syntax.
>
>First name below is JOE:
>
>JDOE19601231001 mycity
>JDOE19601231002 yourcity
>JDOE19601231003 hiscity
>
>Fist name below is JAY:
>
>JDOE19601231001 joecity
>JDOE19601231002 jaycity
>JDOE19601231003 ourcity
>
>The city's name must be completely different to prove they were different persons ID.

I'm still not totally sure what you're looking for, but it looks like SELECT DISTINCT should give you what you need.

Tamar