1 2 3 4 5 6 7 8 9
|
create procedure Get_PERSONNE_byId (@idpersonne bigint)
as
select p.idpersonne, p.idpermis1, p.idpermis2,p.idpermis3,
(select NomPermis from PERSONNE p, Permis ps where p.idpermis1=ps.idpermis and p.idpersonne=@idpersonne) as NomPermis1,
(select NomPermis from PERSONNE p, Permis ps where p.idpermis2=ps.idpermis and p.idpersonne=@idpersonne) as NomPermis2,
(select NomPermis from PERSONNE p, Permis ps where p.idpermis3=ps.idpermis and p.idpersonne=@idpersonne) as NomPermis3
from PERSONNE p
return |
Partager