Figured it out!

select h.invoicedate,
(select max(b.invoicedate)
from hrsworked b
where b.invoicedate < h.invoicedate) as bt
from hrsworked h

Thanks.



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Dion
Sent: 20 May 2006 04:47 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Subselect

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]




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links







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


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