Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- u.id as adminID,
- u.fullName as fullName,
- (
- select @data = ''
- select coalesce(@data + ',','') + CAST(p.title AS VARCHAR(50))
- from adminPermission p
- INNER JOIN adminUserPermissionAssoc a
- ON p.id = a.adminPermissionID
- WHERE a.adminUserID = adminUser.id
- ) as permissionGroups
- FROM
- adminUser u
- WHERE
- u.username = 'psawhney'
- AND u.password = 'a8eaf1d74dc182ad4f9ff4b775dae756'
Add Comment
Please, Sign In to add comment