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.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.