Re: Help reuired for sub-query

Hi Sybrand,

I removed the Select Max(effective_date) from the first select statement and it ran perfect.

Thank you very much for your help, it is really appreciated as I am a newbie to SQL.

--
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.