Třídová akce

Kód:

7

Tělo:

SELECT A.ID
FROM IntrastatReports A 
WHERE (((:DocDate >= A.DateFrom$DATE) and (:DocDate <= A.DateTo$DATE)) or
      ((:oldDocDate >= A.DateFrom$DATE) and (:OldDocDate <= A.DateTo$DATE)))
      and
      ((A.Status = 1) or (A.Status = 2))
      and
      ((A.Origin = 0) or (A.Origin = 1))  
      and 
      not exists (select B.IntrastatReport_ID from IntrastatReportchange B where B.IntrastatReport_ID = A.ID)

Generated by ABRA Software a.s. 27.10.2021 16:34:09