Objektová akce

Kód:

1

Tělo:

SELECT (PL.Code || ' ' || PL.Name || '/' || SC.Code || ' ' || SC.Name || '/' || PD.Code || ' ' || PD.Name) AS DISPLAYNAME 
FROM 
  StorePrices2 SP2
  join PriceDefinitions PD on PD.ID = SP2.Price_ID
  join StorePrices SP on SP.ID = SP2.Parent_ID 
  join StoreCards SC on SC.ID = SP.StoreCard_ID
  join PriceLists PL on PL.ID = SP.PriceList_ID 
 WHERE SP2.ID=:OBJID

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