Třídová akce

Kód:

10

Tělo:

SELECT
  A.ID,
  A.CODE,
  A.NAME,
  SU.ID as StoreUnit_ID,
  SU.Code as QUnit,
  SU.UnitRate,
  SC.Quantity,
  SU.IndivisibleQuantity,
  SC.ID as StoreSubCard_ID
FROM
  StoreCards A
  LEFT JOIN storeunits SU ON SU.parent_id=A.ID
  LEFT JOIN storesubcards SC ON SC.storecard_id=A.ID
WHERE
  ((Upper(A.Name collate pxw_csy) LIKE :Name) or
   (Upper(A.Code collate pxw_csy) LIKE :Name)) and
  (A.Hidden = 'N') and
  (SC.store_id =:Store_Id)
ORDER BY
  Name

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