Třídová akce

Kód:

1

Tělo:

SELECT 
  MAX(DA.Firm_ID) as Firm_ID,
  MAX(F.Code) as Firm_Code,
  MAX(F.Name) as Firm_Name,
  MAX(DA.FirmOffice_ID) as FirmOffice_ID,
  MAX(FO.Name) as FirmOffice_Name,
  Count(DA.ID) as ItemsCount
FROM 
  DemandAnswers DA
  left join Firms F on F.ID = DA.Firm_ID
  left join FirmOffices FO on FO.ID = DA.FirmOffice_ID
WHERE
  DA.DemandingStatus=:DemandingStatus
GROUP BY
  DA.Firm_ID, DA.FirmOffice_ID

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