Třídová akce

Kód:
23
Tělo:
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