Třídová akce

Kód:

6

Tělo:

SELECT DISTINCT
  A.ID as ID
FROM
  DemandAnswers A
  JOIN DemandSheets2 DS2 ON DS2.ID = A.Parent_ID 
WHERE 
  A.Firm_ID = :Firm_ID AND
  A.FirmOffice_ID = :FirmOffice_ID AND
  A.DemandingStatus = 2 AND
  DS2.StoreCard_ID = :StoreCard_ID AND
  A.GOTPRICESDATE$DATE IN
    (SELECT MAX(A2.GOTPRICESDATE$DATE)
    FROM
      DemandAnswers A2
      JOIN DemandSheets2 DS22 ON DS22.ID = A2.Parent_ID 
    WHERE
      A2.Firm_ID = :Firm_ID AND
      A2.FirmOffice_ID = :FirmOffice_ID AND
      A2.DemandingStatus = 2 AND
      DS22.StoreCard_ID = :StoreCard_ID)
  

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