Třídová akce

Kód:

7

Tělo:

Select
  SL.StoreCard_ID
from
  StoreCardMenuItemLinks SL
  join StoreCards SC on SC.ID = SL.StoreCard_ID and SC.Hidden='N' and SL.StoreMenuItem_ID = :StoreMenuItem_ID

UNION

Select
  SL.StoreCard_ID
from
  StoreCardMenuItemLinks SL
  join SYS$StoreMenu2 SM2 on SM2.ID = SL.StoreMenuItem_ID and SM2.Superior_ID = :StoreMenuItem_ID
  join StoreCards SC on SC.ID = SL.StoreCard_ID and SC.Hidden='N'
/* rychlostni optimalizace - i 2 uniony jsou radove rychlejsi nez vnorene poddotazy*/  

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