select PE.id
from
periods PE
where
PE.dateto$date = (
select
min(pe.dateto$date)
from
sys$posdocumentsopened os
left join posdocuments a on os.id=a.id
left join periods PE on PE.id = A.period_id
where
(os.opened = 'A') or
(os.IsPayChange = 'A'))Generated by ABRA Software a.s. 27.10.2021 16:34:30