Connecting Red Dots ::: OpenText Web Site Management
Wednesday, 21 May 2014
How to find all the User for Given Project
SELECT usr2,usr3,usr8
FROM [IoAdministration].[dbo].[IO_
USR]
where usr0 in (SELECT rel1
FROM [IoAdministration].[dbo].[IO_
REL]
where rel3= 'Projectid'
and rel2 = 'USR')
order by usr2
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment