GilaMonster (10/6/2008)

---

How about something like this?

select < column list > from users inner join

(SELECT User_ID, MAX(Start_Date) as LatestStartDate FROM Users group by User_ID) sub

on Users.User_ID = sub.User_ID...

OK, well at the risk of sending this thread spiraling into 2k5 VB.net land and hoping theres a few here with knowledge in both.

First the Access level was just for...

ok I think I need to clarify a little bit.

Table Users has we will say 5 fields

User_ID, FirstName,LastName,StartDate,AccessLevel

Rows look something like this

User_ID | FirstName | LastName | StartDate ...

Nevermind.... I managed to figure it out.

andrew gothard (8/14/2008)

---

If this doesn't help, can you post a little more detail? Jack Corbetts sig gives a link to a good guide to the type of info that's...