Třídová akce

Kód:

9

Tělo:

SELECT
  A.ClosingDate$DATE, A.Period_ID
FROM
  StoreClosings A
  join Seldat SLD on SLD.Obj_ID = A.Store_ID and Sel_ID = :Sel_ID
WHERE
  A.ClosingDate$DATE =
  (
  SELECT MAX(ClosingDate$DATE)
  FROM StoreClosings SC
  join Seldat SLD on SLD.Obj_ID = SC.Store_ID and Sel_ID = :Sel_ID
  )
ORDER BY
  A.Period_ID  

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