FSe User Lookup
SELECT secs.sectionid, secs.section, secs.sectionRank, secs.privateFlag, cats.attrID, cats.attrDescription
FROM tbl_CMM_Sections secs, tbl_ORG_AttributeLinks link, tbl_ORG_Attributes cats
WHERE secs.OwnerID =
AND secs.FSL_TableCode =
AND secs.sectionid = link.mstr_attrID
AND link.mstr_attrTypeID = 25
AND link.child_attrTypeID = 26
AND link.child_attrID *= cats.attrID
AND cats.attrTypeID = 26
AND cats.OwnerID =
AND cats.FSL_TableCode =
UNION ALL
SELECT secs.sectionid, secs.section, secs.sectionRank, secs.privateFlag, '0' AS attrID, '' AS attrDescription
FROM tbl_CMM_Sections secs
WHERE NOT EXISTS (SELECT link.mstr_attrID
FROM tbl_ORG_AttributeLinks link
WHERE secs.sectionid = link.mstr_attrID
AND link.mstr_attrTypeID = 25
AND link.child_attrTypeID = 26)
AND secs.OwnerID =
AND secs.FSL_TableCode =
ORDER BY secs.section, secs.sectionRank, attrDescription;