--- In firebird-support@yahoogroups.com, "Dion" wrote:

>
> I need to return a max value per record plus another field in
> subselect. Is this possible?

No, it is not possible, you have to do something like

select a.whatever, (select max(b.fieldB) from b where a.fieldA = b.id)
as B_Max, (select b.datefield from b c where a.fieldA = c.id as B_Date)
from a