>SELECT RO.FirstName >FROM (SELECT TOP 10 Event.RO_No,Min(Event.DateTime) AS LastUpdate > FROM Event > INNER JOIN RO ON Temp.RO_No=RO.RO_No > WHERE Event_Log.Event_DateTime>'Something' > GROUP BY Event.RO_No > ORDER BY MIN(Event.Datetime)) Temp >INNER JOIN RO ON Temp.RO_No=RO.RO_No >
SELECT TOP 10 Event.RO_No, Min(Event.DateTime) AS LastUpdate, min(Ro.FirstName) as FirstName FROM Event inner join RO on Event.Ro_No = RO.Ro_No WHERE Event.Event_DateTime>'SomDate' GROUP BY Event.RO_No ORDER BY MIN(Event.Datetime) and not exists(select 1 from Event E where E.DateTim < ='SomeDate' and E.Ro_No = RO.Ro_NO)