Subject | RE: [firebird-support] Re: Subquery Question (FB 1.5) |
---|---|
Author | Maya Opperman |
Post date | 2010-07-07T15:26:17Z |
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)
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)