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