Re: Help reuired for sub-query

Hi Sybrand,

Thank you for replying so promptly, being a newbie to SQL, I was not sure if I was posting my questions in the correct group.

As I do not need to see the date, I solved the problem by not selecting the Max Date in the first select.

select es.employee_number "Clock No.",
max(es.effective_date) "Max Date",
es.assigned_department "Dept"

You have saved me a few sleepless nights.

--
Rgds
Raymond
http://www.fmedit.pwp.blueyonder.co.uk/html/fmedit.htm
      (For the ideal Explorer replacement)


Sent via Deja.com http://www.deja.com/
Before you buy.