Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.65 KB | None | 0 0
  1. SELECT DISTINCT PD.vch_FirstName + ' ' + PD.vch_PersonSurName AS Name
  2. FROM tbl_UserGroup UG
  3.         INNER JOIN tbl_UserUserGroup UUG ON  UUG.int_UserGroupId = UG.int_UsergroupId
  4.         INNER JOIN tbl_Users U ON U.int_UserId = UUG.int_UserId
  5.         INNER JOIN tbl_PersonalData PD ON PD.int_PersonalDataId = U.int_PersonalDataId
  6. WHERE U.int_UserId <>  1 AND UG.vch_GroupName IN
  7.                 (
  8.                     SELECT UG2.vch_GroupName
  9.                     FROM tbl_UserGroup UG2
  10.                         INNER JOIN tbl_UserUserGroup UUG2 ON  UUG2.int_UserGroupId = UG2.int_UsergroupId
  11.                         INNER JOIN tbl_Users U2 ON U2.int_UserId = UUG2.int_UserId AND U2.int_UserId = 1
  12.                 )
  13. GROUP BY PD.vch_FirstName, PD.vch_PersonSurName
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement