Objektová akce

Kód:

1

Tělo:

SELECT AA.Code, F.Code, FO.Name 
FROM ApprovedSuppliers A
JOIN ApprovingAreas AA ON A.ApprovingArea_ID = AA.ID
JOIN Firms F ON A.Firm_ID = F.ID
LEFT JOIN FirmOffices FO ON A.FirmOffice_ID = FO.ID
WHERE 
  A.ID = :OBJID

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