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?? :)
Select employee, emplAtrib1, ..., event, eventAtrib1, eventDate
From employee JOIN event on employee.emplID = event.emplID
AND event.eventDate=(SELECTMAX(eventDate) FROM event WHERE event.emplID=employee.emplID)