Objektová akce

Kód:

2

Tělo:

SELECT A.ID 
FROM SCMDataSources A 
WHERE (A.Kind IN (1, 2))

UNION

SELECT C.StoreCardsSource_ID 
FROM SCMColumnsDefinitions2 A
JOIN SCMColumnsDefinitions B ON B.ID = A.Parent_ID
JOIN SCMSettings C ON C.ID = B.Setting_ID

UNION

SELECT C.StoresSource_ID 
FROM SCMColumnsDefinitions2 A
JOIN SCMColumnsDefinitions B ON B.ID = A.Parent_ID
JOIN SCMSettings C ON C.ID = B.Setting_ID

Generated by ABRA Software a.s. 27.10.2021 16:35:29