Hi,



Each record in the returned dataset must return a value indicating the max
invoicedate excluding the one on the current row in table HrsWorked. The
following is logically what I want to achieve, but does not compile:-



select *

from hrsworked h, (select max (b.invoicedate)

from hrsworked b << error here, column not
recognized(h.invoicedate) >>

where b.invoicedate < h.invoicedate) as initid



Thanks,

Dion.










--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 17/05/2006



[Non-text portions of this message have been removed]