Objektová akce

Kód:

10

Tělo:

SELECT 
  A.ID 
FROM 
  DemandAnswers A
  JOIN DemandSheets2 B ON B.ID = A.Parent_ID
  JOIN DemandSheets C ON C.ID = B.Parent_ID
  JOIN Currencies D ON D.ID = A.Currency_ID 
WHERE 
  C.ID = :OBJID AND
  A.IsWinner = 'A' AND
  A.DemandingStatus = 2
ORDER BY
  A.Firm_ID,
  D.Code,
  A.Currency_ID

Generated by ABRA Software a.s. 27.10.2021 16:35:50