Hello, all. I'm having trouble getting a query to work. Here it is:
Code:
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)?

Thank you for any assistance with this matter.

bubbis