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 28 29 30
|
SELECT Matricule, NomPers
FROM Personne, ParticipeProjet
WHERE NumProjet="756"
AND NbJours IN (SELECT MAX(NbJours)
FROM PartcipeProjet
Mauvais ! Solution :
avec correlation :
SELECT P.Matricule, NomPers
FROM Personnel P
INNER JOIN ParticipeProjet PP
ON P.Matricule = PP.Matricule
WHERE NumProjet = 756
AND NbJours = (SELECT MAX(NbJours)
FROM ParticipeProjet
WHERE NumProjet = PP.NumProjet)
sans corrélation :
SELECT P.Matricule, NomPers
FROM Personnel P
INNER JOIN ParticipeProjet PP
ON P.Matricule = PP.Matricule
WHERE NumProjet = 756
AND NbJours = (SELECT MAX(NbJours)
FROM ParticipeProjet
WHERE NumProjet = 756) |
Partager