Třídová akce

Popis:

Pro načtení do záložky Souvislosti

Kód:

9

Tělo:

select
  BO.Code as DisplayName,
  BO.Name as Description,
  BO.Date$DATE as Date$Date,
  BO.ID as ID,
  BO.Firm_ID as FirmID
from 
  BusOrders BO
  join Firms F on F.ID = BO.Firm_ID   
where 
  (F.ID = :ID or F.Firm_ID = :ID)
  and BO.Hidden = 'N'
  and (BO.Date$DATE >= :DateFrom) and (BO.Date$DATE < :DateTo + 1)  

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