Třídová akce

Kód:

8

Tělo:

SELECT
  SUM(IO2.Quantity - IO2.DeliveredQuantity) AS Quantity
FROM
  IssuedOrders IO
  JOIN IssuedOrders2 IO2 ON IO2.Parent_ID = IO.ID
WHERE
  (IO.Closed = 'N') AND (IO.Confirmed = :Confirmed) 
  AND (IO2.StoreCard_ID = :StoreCard_ID) AND (IO2.Store_ID = :Store_ID)
  AND (IO.Revided_ID IS NULL)

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