Objektová akce

Kód:

1

Tělo:

SELECT P.LastName||' '||P.FirstName||' '||P.Title||' '|| CAST(W.BeginDate$DATE AS VARCHAR(30)) ||'-'|| CAST(W.EndDate$DATE AS VARCHAR(30)) ||'-'||ET.Code
  FROM WLWorkLogs W 
  JOIN Persons P ON P.ID = W.Worker_ID
  JOIN WLEntryTypes ET ON ET.ID = W.EntryType_ID
  WHERE W.ID=:OBJID

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