Třídová akce

Kód:

7

Tělo:

SELECT
  SUM(RO2.Quantity - RO2.DeliveredQuantity) AS Quantity
FROM
  ReceivedOrders RO
  JOIN ReceivedOrders2 RO2 ON RO2.Parent_ID = RO.ID
WHERE
  (RO.Closed = 'N') AND (RO.Confirmed = :Confirmed) 
  AND (RO2.StoreCard_ID = :StoreCard_ID) AND (RO2.Store_ID = :Store_ID)
  AND (RO.Revided_ID IS NULL)

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