Třídová akce

Kód:

9

Tělo:

Select ISet2.identifier as Identifier,  ISet.Name as Name, Coalesce(Max(IVer.Version), 0) as Version FROM InstallSets2 ISet2
LEFT JOIN Installsets ISet on ISet.ID = Iset2.Parent_ID
LEFT JOIN InstallSetVersions IVer on IVer.Parent_ID = ISet.ID
LEFT JOIN InstallSetVersions2 Iver2 on IVer2.Parent_ID = IVer.ID
WHERE (ISet2.Parent_ID <> :InstallSetID) and (ISet2.ISClassID = :ISClassID) and (ISet2.Identifier=:Identifier)
GROUP BY ISet2.identifier,  ISet.Name

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