Třídová akce

Kód:

6

Tělo:

SELECT 
  SUM(A.Reserved - A.Supplied)
FROM 
  Reservations A
WHERE 
  (A.Store_ID = :Store_ID) 
  AND (A.Storecard_ID = :StoreCard_ID) 
  AND (A.Priority < :Priority) 
  AND (A.Reserved > A.Supplied) 
  AND (((A.DateTo$Date = 0) AND (A.DateFrom$Date <= :Doc_Date)) 
    OR ((A.DateTo$Date >= :Doc_Date2) AND (A.DateFrom$Date <= :Doc_Date)))
  AND (A.Revided_ID IS NULL)

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