Je rencontre une difficulté à faire la requête suivante qui devrait me
donner :
Liste des employés ayant le même Job et le même supérieur hiérarchique que
HUERT.
SELECT NumEmp, NomEmp
FROM EMPLOYES
WHERE (JobEmp, NumEmpSup) =
(SELECT JobEmp, NumEmpSup
FROM EMPLOYES
WHERE NomEmp = "HUERT" ) ;
Telle quelle cela ne fonctionne pas.
Qui aurait une idée ?
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Luiz Cláudio
Hi Bruno,
try this one:
SELECT T1.NumEmp, T1.NomEmp FROM Employes AS T1 INNER JOIN (SELECT * FROM Employes WHERE NomEmp "Huert") AS T2 ON T1.NomEmpSup = T2.NomEmpSup AND T1.JobEmp = T2.JobEmp;
Luiz Cláudio C. V. Rocha São Paulo - Brasil
Hi Bruno,
try this one:
SELECT T1.NumEmp, T1.NomEmp
FROM Employes AS T1 INNER JOIN (SELECT * FROM Employes WHERE NomEmp "Huert") AS T2
ON T1.NomEmpSup = T2.NomEmpSup AND T1.JobEmp = T2.JobEmp;
SELECT T1.NumEmp, T1.NomEmp FROM Employes AS T1 INNER JOIN (SELECT * FROM Employes WHERE NomEmp "Huert") AS T2 ON T1.NomEmpSup = T2.NomEmpSup AND T1.JobEmp = T2.JobEmp;
Luiz Cláudio C. V. Rocha São Paulo - Brasil
BRUNO
Thanks BC "Luiz Cláudio" a écrit dans le message de news:
Hi Bruno,
try this one:
SELECT T1.NumEmp, T1.NomEmp FROM Employes AS T1 INNER JOIN (SELECT * FROM Employes WHERE NomEmp > "Huert") AS T2 ON T1.NomEmpSup = T2.NomEmpSup AND T1.JobEmp = T2.JobEmp;
Luiz Cláudio C. V. Rocha São Paulo - Brasil
Thanks
BC
"Luiz Cláudio" <lui@link.com.invalid> a écrit dans le message de
news:eGFUz6tAEHA.576@TK2MSFTNGP11.phx.gbl...
Hi Bruno,
try this one:
SELECT T1.NumEmp, T1.NomEmp
FROM Employes AS T1 INNER JOIN (SELECT * FROM Employes WHERE NomEmp > "Huert") AS T2
ON T1.NomEmpSup = T2.NomEmpSup AND T1.JobEmp = T2.JobEmp;
Thanks BC "Luiz Cláudio" a écrit dans le message de news:
Hi Bruno,
try this one:
SELECT T1.NumEmp, T1.NomEmp FROM Employes AS T1 INNER JOIN (SELECT * FROM Employes WHERE NomEmp > "Huert") AS T2 ON T1.NomEmpSup = T2.NomEmpSup AND T1.JobEmp = T2.JobEmp;