Forum Discussion
Swoop
12 years agoFrequent Contributor
The reply from support didnt provide me with what I requested, so I came up with this query, which seemed to do the trick. (22427 was what SecurityAdmin evaluated to in the SecurityGroups table)
SELECT Persons.FirstName + ' ' + Persons.LastName AS SecurityAdmin, Projects.ProjName
FROM PersonSecurityGroups, Projects, Persons
WHERE SecurityGroupId=22427
AND PersonSecurityGroups.ProjId=Projects.ProjId
AND PersonSecurityGroups.UserId=Persons.UserId
ORDER BY ProjName ASC
SELECT Persons.FirstName + ' ' + Persons.LastName AS SecurityAdmin, Projects.ProjName
FROM PersonSecurityGroups, Projects, Persons
WHERE SecurityGroupId=22427
AND PersonSecurityGroups.ProjId=Projects.ProjId
AND PersonSecurityGroups.UserId=Persons.UserId
ORDER BY ProjName ASC
Related Content
- 12 years ago
- 3 years ago