Yes, we are seriously lagging behind with FB 1.5 and I would like to
move to 2.5.
Trouble is that this is something beyond our control; controlled by iSoft / CSC.

RBS

On 8/30/12, Michael Ludwig <milu71@...> wrote:
> Bart Smissaert schrieb am 19.08.2012 um 14:13 (+0100):
>> Firebird 1.5, classic on Windows.
>
>> delete from keyword k where
>> not k.rdb$db_key in (select
>> max(k2.rdb$db_key)
>> from
>> keyword k2
>> group by
>> k2.term_key,
>> k2.term_id)
>
>> Why does the delete SQL not work?
>
> Works fine for me on: WI-V2.5.1.26351 Firebird 2.5
>
> Michael
>