SELECT [PSU0]
,[PSU2]
,[PSU3]
,[PSU4]
FROM [Project Name].[dbo].[IO_PSU]
order by psu2
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
,[PSU2]
,[PSU3]
,[PSU4]
FROM [Project Name].[dbo].[IO_PSU]
order by psu2
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