Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: GROUP BY and LEFT OUTER JOIN...
10-24-2005, 06:13 PM #1
- Join Date
- Jul 2005
- Thanked 0 Times in 0 Posts
GROUP BY and LEFT OUTER JOIN...
Hello, all. I'm having trouble getting a query to work. Here it is:
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
Thank you for any assistance with this matter.