Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT PD.vch_FirstName + ' ' + PD.vch_PersonSurName AS Name
- FROM tbl_UserGroup UG
- INNER JOIN tbl_UserUserGroup UUG ON UUG.int_UserGroupId = UG.int_UsergroupId
- INNER JOIN tbl_Users U ON U.int_UserId = UUG.int_UserId
- INNER JOIN tbl_PersonalData PD ON PD.int_PersonalDataId = U.int_PersonalDataId
- WHERE U.int_UserId <> 1 AND UG.vch_GroupName IN
- (
- SELECT UG2.vch_GroupName
- FROM tbl_UserGroup UG2
- INNER JOIN tbl_UserUserGroup UUG2 ON UUG2.int_UserGroupId = UG2.int_UsergroupId
- INNER JOIN tbl_Users U2 ON U2.int_UserId = UUG2.int_UserId AND U2.int_UserId = 1
- )
- GROUP BY PD.vch_FirstName, PD.vch_PersonSurName
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement