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.

Thx again,