Unique rows that share identification # 1

[scriptscribe]

Hi,

I've need to parse out data to identify duplicate entries in a database that share a License#, but have slightly different names. I want the results to display on a single line for each ID#.

My data looks like this:

Name            Primary Key      ID
Smith,John          1            12345
Smith,Jon           2            12345
Smith,Johnny        3            12345

I need the results to look like this:

Smith,John  1    Smith,Jon    2    Smith,Johnny    3

I'm usually pretty good with queries, but am lost on how to do this without getting a slew of matches, since each row is unique.

Any help would be greatly appreciated.

Mike

 

[Remou]

Have a look at: FAQ701-4233

http://lessthandot.com

 

[scriptscribe]

Thanks!

Star for you.