Třídová akce

Kód:

2

Tělo:

SELECT A.*, B.Color FROM WLWorkLogs A 
LEFT JOIN WLEntryTypes B ON A.EntryType_ID = B.ID
  WHERE (A.Worker_ID = :WorkerID) AND
        (A.BeginDate$DATE < (:DateTo + 1)) AND
        ((A.EndDate$DATE >= :DateFrom) OR (A.EndDate$DATE = 0))
  ORDER BY A.BeginDate$DATE      

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