Objektová akce

Kód:

2

Tělo:

SELECT (PL.Code || ' ' || PL.Name || '/' || SC.Code || ' ' || SC.Name) AS DISPLAYNAME 
FROM 
  ActionStorePrices SP 
  join StoreCards SC on SC.ID = SP.StoreCard_ID
  join ActionPriceLists PL on PL.ID = SP.PriceList_ID 
 WHERE SP.ID=:OBJID

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