SELECT EMPLOYEE.EM_FNAME,EMPLOYEE.EM_LNAME,EMPLOYEE.EM_JOBPOS,MAX(JOBPOS.JP_SDATE) MAXSTARTDATE
FROM EMPLOYEE
LEFT OUTER JOIN JOBPOS
ON EMPLOYEE.EM_ID=JOBPOS.EM_ID
GROUP BY EMPLOYEE.EM_FNAME,EMPLOYEE.EM_LNAME,EMPLOYEE.EM_JOBPOS
ORDER BY EMPLOYEE.EM_FNAME

This query returns what I want it to; but when I request another field from the JOBPOS table, the query returns nothing. What do I need to do to be able to return a field from JOBPOS (aside from MAXSTARTDATE)?