question

MATHEWSM avatar image
MATHEWSM asked

I want to list users that have normal User Access and must also list the groups relevant to each user. this is on two different database [cheeter( has SecurityUserGroupLink [wGroupID & wUserID])] and [GameRanger(has securitygroup [wGroupID & szName])]

SELECT userlist.[wUserListID],

userlist.[szEmployeeNumber]

,userlist.[szUserName]

,userlist.[szTitle]

,userlist.[szInitials]

,userlist.[szFirstName]

,userlist.[szSurname],(SELECT TOP 1 szName FROM [GameRanger].[dbo].[SecurityGroup] WHERE [wGameRangerLevel] = 1 AND [GameRanger].[dbo].[SecurityGroup].wGroupID BETWEEN 2 AND 9)

FROM [Cheetah].[dbo].[UserList] userlist

INNER JOIN [GameRanger].[dbo].[SecurityUserGroupLink] securityusergrouplink on wUserListID = securityusergrouplink.wUserID

selectsub-query
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.