1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
SELECT
[...] ,
(SELECT Username
FROM viza.dbo.UserJeu AS a1
WHERE UserId = (SELECT UserId_FK
FROM viza.dbo.VisitUserJeu
WHERE VisitRoleId_FK = (SELECT VisitRoleId
FROM viza.dbo.VisitRoleJeu
WHERE Name = 'Auditeur')
AND VisitId_FK = viza.dbo.SourceJeu.SourceId))
AS "Auditeur n°1",
(SELECT Username
FROM viza.dbo.UserJeu
WHERE UserId <> (SELECT UserId
FROM viza.dbo.UserJeu
WHERE Username = a1)
AND UserId = (SELECT UserId_FK
FROM viza.dbo.VisitUserJeu
WHERE VisitRoleId_FK = (SELECT VisitRoleId
FROM viza.dbo.VisitRoleJeu
WHERE Name = 'Auditeur')
AND VisitId_FK = viza.dbo.SourceJeu.SourceId))
AS "Auditeur n°2",
[...]
FROM viza.dbo.SourceJeu
WHERE [...] |
Partager