OK, this should be easy, but it seems I am having one of those days. I have two tables, employee and event. I have a view where I need to see all of the employee's and only the most recent event, by eventDate:

Select employee, emplAtrib1, ..., event, eventAtrib1, eventDate
From employee INNER JOIN event on employee.emplID = event.emplID

But only the most recent event.

Can anyone help the brain dead this morning?? :)

Thanks in advance.