SELECT employee.*,employeestatus.*
FROM employee INNER JOIN
employeestatus ON employee.empid = employeestatus.empid
WHERE (employeestatus.statusid =
(SELECT MAX(statusid)
FROM employeestatus AS status_temp
WHERE (empid = employee.empid)))
That will get you all the columns of employee status.