select id
from
periods per
where
per.datefrom$date = (
select
max(pe.datefrom$date)
from
POSRECEIPTS PR
join periods PE on pe.id=pr.period_id
where
DocQueue_ID = :DocQueue_ID and
VirtualPOS_ID = :VirtualPOS_ID)Generated by ABRA Software a.s. 27.10.2021 16:34:30