Třídová akce

Kód:

2

Tělo:

SELECT {FIELDS}
FROM IssuedOfferStateChanges A
  JOIN IssuedOffers B on B.ID = A.IssuedOffer_ID
  LEFT JOIN IssuedOfferTypes C on C.ID = B.IssuedOfferType_ID
  LEFT JOIN IssuedOfferStateToType D on D.Parent_ID = C.ID and D.IssuedOfferState_ID = A.OfferState_ID
WHERE A.IssuedOffer_ID = :IssuedOffer_ID
  AND RealDate$DATE = 0
ORDER BY PlanDate$DATE, OrderNr

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