Třídová akce

Kód:

16

Tělo:

select COALESCE(F.Firm_ID, F.ID) Firm_ID, 
     A.DocDate$DATE LatestDate, 
     A.ID LatestID 
 FROM IssuedOffers A
 JOIN Firms F ON F.ID = A.Firm_ID
 WHERE
   A.{FirmFieldName} {Firm_IDs} AND
   A.DocDate$DATE >= :DateFrom AND
   A.DocQueue_ID {DocQueue_IDs}

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