HELP

This maybe a bit easy for someone. here's what i want to do. say i have a TEAM table

create table Team
(
  ID int
  TeamName varchar(50),
   Player varchar (20)
)
my current population of this table is this

ID        TeamName          Player
            Team1                 Mike
            Team1                 David
            Team1                 Henry
            Team2                 Derik
            TEam2                Jerry

the result i want to have a query looks like this:

ID        TeamName          Player
1            Team1                 Mike
2            Team1                 David
3            Team1                 Henry
1            Team2                 Derik
2            TEam2                Jerry

anyone have any ideas? the id doesn't have to be alphabetically order of the player's name. I just want the order of the ID the way it display now.

thanks Received on Tue Jun 11 2002 - 03:35:31 CDT