Gruppenrechte auf RequestTemplates

SELECT tblTemplate.Id AS TemplateId,tblTemplate.Name AS TemplateName,tblSchemaRequest.Name AS RequestName,tblGroupUserSecurityObject.Rights,Tblgroup.name AS GROUPName

FROM tblTemplate

INNER JOIN tblSchemaRequest ON tblTemplate.SchemaRequest_id = tblSchemaRequest.id

INNER JOIN tblGroupUserSecurityObject ON tblTemplate.id = tblGroupUserSecurityObject.Object_id

INNER JOIN tblGroup ON tblGroupUserSecurityObject.GroupUser_Id = tblGroup.id ;