Objektová akce

Kód:

1

Tělo:

select P.FirstName || ' ' || P.LastName || ' - ' || EP.Code || ' ' || WPD.Code || ' ' || WPA.Code      
from 
  MonthWRelationInformation WRMI
join WorkingRelations WR on WR.ID = WRMI.WorkingRelation_ID
join Persons P on P.ID = WR.Employee_ID
join EmployPatterns EP ON EP.ID = WR.EmployPattern_ID   
join WagePeriods WPD on WPD.ID = WRMI.WagePeriod_ID
join WagePeriods WPA on WPA.ID = WRMI.WagePeriodAuthor_ID

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