Select group number for distinct rows based on two columns

[shaini b]

Hi,
I have a problem, need to number the distinct rows based on two columns.
Eg, I have the table like this:

ID FirstName LastName
=================================
1 Leuis Red
2 Red Leuis
3 Leuis Kit
4 Jane Fonda
5 James White
6 White James

I need a query to get the result like this:

Group Name
=================
1 Leuis
1 Red
1 Kit
2 Jane
2 Fonda
3 James
3 White

Please help me,
Thanks
Shaini.



Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .Net Tips & Tricks #21
http://www.eggheadcafe.com/tutorial...a097-dd7f54909272/dr-dotnetskys-cool-net.aspx

 

[Clifford Bass via AccessMonster.com]

Hi Shaini,

I am missing what rule(s) your are applying to transform the data from
the one form into the other. On what basis does a name go into a particular
group number?

Clifford Bass