Třídová akce

Kód:

4

Tělo:

select
  A.ID, A.DocDate$DATE
from 
  EmailsReceived A
where
  A.Person_ID = :Person_ID
  and A.DocDate$DATE >= :DocDate$DATE

union select
  A.ID, A.DocDate$DATE
from 
  EmailsReceived A
where
  A.Firm_ID IN (SELECT ID FROM Firms WHERE ID=:Firm_ID OR Firm_ID=:Firm_ID2)
  and A.DocDate$DATE >= :DocDate$DATE

union select
  A.ID, A.DocDate$DATE
from 
  EmailsReceived A
where
  A.FirmOffice_ID = :FirmOffice_ID
  and A.DocDate$DATE >= :DocDate$DATE

order by 2, 1    

Generated by ABRA Software a.s. 27.10.2021 16:35:16