Třídová akce

Popis:

Hledání podle kódu a názvu a jména firmy výrobce pro Servisní dispečink

Kód:

19

Tělo:

SELECT
  A.ID
FROM
  StoreCards A
  LEFT JOIN Firms F ON F.ID=A.Producer_ID
WHERE
  ((Upper(A.Name collate PXW_CSY) LIKE Upper('{SEARCHCARD}') ESCAPE '~') OR
   (Upper(A.Code collate PXW_CSY) LIKE Upper('{SEARCHCARD}') ESCAPE '~')) AND
  ((Upper(F.Name collate PXW_CSY) LIKE Upper('{SEARCHPRODUCER}') ESCAPE '~') OR
   (('{SEARCHPRODUCER}'='%%') AND A.Producer_ID is null) OR
   ((:WithAncestors='A') AND
    (A.Producer_ID in
     (SELECT F1.ID FROM Firms F1
      WHERE
       (A.Producer_ID = F1.ID) and
       (F1.Firm_ID in 
        (SELECT F11.ID FROM Firms F11 
         where (Upper(F11.Name collate PXW_CSY) LIKE Upper('{SEARCHPRODUCER}') ESCAPE '~')
        )
       )
     )
    ) 
   )
  )
ORDER BY
  A.Name

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