B
bukky_bu
Sample list of records:
DATE LAST_NM FIRST_NM INT_ID OTHER
1) 20070301 DOE JANE 12345 XXXXXXX
2) 20061102 DOE JANE 12345 XXXXXXX
3) 20060713 SMITH JANE 12345 XXXXXXX
4) 20060322 SMITH JANE 12345 XXXXXXX
5) 20050916 DOE JANE 12345 XXXXXXX
6) 20050427 DOE JANE 12345 XXXXXXX
7) 19990609 DOE JANE 12345 XXXXXXX
How do I pull records 1, 3 and 5? There are numerous other fields, but
none with any distinguishing characteristics. What I am trying to get
is an individual's name change history. This particular person changed
their name from Doe to Smith and back to Doe again. Everything I've
tried up to this point has
given me one instance each of Doe and Smith (1 and 3) when I really
need to return one instance of Smith and two instances of Doe (1, 3
and 5). Any advice?
DATE LAST_NM FIRST_NM INT_ID OTHER
1) 20070301 DOE JANE 12345 XXXXXXX
2) 20061102 DOE JANE 12345 XXXXXXX
3) 20060713 SMITH JANE 12345 XXXXXXX
4) 20060322 SMITH JANE 12345 XXXXXXX
5) 20050916 DOE JANE 12345 XXXXXXX
6) 20050427 DOE JANE 12345 XXXXXXX
7) 19990609 DOE JANE 12345 XXXXXXX
How do I pull records 1, 3 and 5? There are numerous other fields, but
none with any distinguishing characteristics. What I am trying to get
is an individual's name change history. This particular person changed
their name from Doe to Smith and back to Doe again. Everything I've
tried up to this point has
given me one instance each of Doe and Smith (1 and 3) when I really
need to return one instance of Smith and two instances of Doe (1, 3
and 5). Any advice?