Subject RE: [firebird-support] Re: Subquery Question (FB 1.5)
Author Maya Opperman
TRY:

select
watlev.inventory_pk,
watlev.wl_date,
watlev.wl_comment
from watlev
where watlev.inventory_pk =
(select
first 1
w.inventory_pk
from watlev w
order by w.wl_date desc)