Select
A.Code as DisplayName,
A.Name as Description,
A.DateOfSale$DATE as Date$DATE,
A.ID as ID,
A.Firm_ID as FirmID
from
ServicedObjects A
where
(A.Firm_ID IN (SELECT ID FROM Firms WHERE ID=:ID or BusProject_ID=:ID))
and (A.DateOfSale$DATE >= :DateFrom) and (A.DateOfSale$DATE < :DateTo + 1)Generated by ABRA Software a.s. 27.10.2021 16:35:46