Objektová akce

Kód:

4

Tělo:

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

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