Třídová akce

Kód:

8

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(Name collate pxw_csy) LIKE :Name) and
  (Hidden = 'N') and
  (SC.store_id =:Store_Id)
ORDER BY
  NAME

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