Třídová akce

Kód:

6

Tělo:

SELECT 
  A.ID as ID, 
  B.ID as UnitID, 
  C.ID as EANID
FROM 
  StoreCards A
  join StorePrices SP on SP.StoreCard_ID = A.ID and PriceList_ID = :PriceListID
  join StoreUnits B on B.Parent_ID = A.ID
  join StoreEANs C on C.Parent_ID = B.ID
WHERE
 (C.EAN = :EAN) and (A.Hidden = 'N')

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