Thanks again! I just used this again.

>There're many ways to get such result. Pick one that is most efficient for your data
>

>* 1
>SELECT * FROM mytable mt1 
>  WHERE StartDate = (SELECT MAX(StartDate) FROM mytable mt2 where mt2.fk = mt1.fk)
>
>* 2
>SELECT * FROM mytable mt1 
>  JOIN (SELECT fk, MAX(StartDate) AS MaxStartDate FROM mytable GROUP BY fk) dt1
>    ON dt1.fk = mt1.fk AND dt1.MaxStartDate = mt1.StartDate 
>
>* 3
>SELECT * FROM mytable mt1 
>  WHERE NOT EXISTS (SELECT 1 FROM mytable mt2 where mt2.fk = mt1.fk AND mt2.StartDate > mt1.StartDate)
>

>
>>I'm having a group by brain-fart. Somebody please point me in the right direction...
>>
>>I have the following data:
>>

>>ID|FK|Status|StartDate
>>1|1|Started|1/1/2008
>>2|1|Finished|1/2/2008
>>3|2|Started|3/2/2008
>>4|3|Started|5/1/2008
>>5|3|Finished|5/4/2008
>>

>>
>>This is a transactional flow of items through statuses. I would like to see what status each item is currently set to, which should be the greatest StartDate. In my example, I want to see:
>>

>>FK|Status
>>1|Finished
>>2|Started
>>3|Finished
>>

>>
>>Thanks in advance!