Objektová akce

Kód:

7

Tělo:

select min(DS2.Name) as FieldName
from (
    select distinct CD.ID as ColDef_ID, CD2.DataSource_ID
    from SCMColumnsDefinitions CD
    join SCMColumnsDefinitions2 CD2 on CD2.Parent_ID = CD.ID
) A    
join SCMDataSources2 DS2 on DS2.Parent_ID = A.DataSource_ID
where A.ColDef_ID = :OBJID
group by upper(DS2.Name)
having count(*) = (select count(*)
                   from (
                       select distinct CD.ID as ColDef_ID, CD2.DataSource_ID
                       from SCMColumnsDefinitions CD
                       join SCMColumnsDefinitions2 CD2 on CD2.Parent_ID = CD.ID
                   ) B
                   where B.ColDef_ID = :OBJID)

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