[2012] Problème jointure multiple

SELECT Vendeurs.id_vendeur, Vendeurs.VendeurInit, Vendeurs.VendeurNom, COUNT(Devis.DevNum)as devs, COUNT(Commandes.CdeNum) as cmds FROM Vendeurs FULL JOIN Devis ON Vendeurs.id_vendeur = Devis.id_vendeur FULL JOIN CommandesDevis ON Devis.id_devis = CommandesDevis.id_devis FULL JOIN Commandes ON Commandes.id_commande = CommandesDevis.id_commande INNER JOIN Temps ON Devis.DevDate = Temps.id_temps WHERE Temps.id_temps >= '17899' and Temps.id_temps <= '17906' GROUP BY Vendeurs.id_vendeur, Vendeurs.VendeurInit, Vendeurs.VendeurNom ORDER BY Vendeurs.id_vendeur;

C'est normal, vous utilisez un FULL OUTER join !!!!

AU passage connnaissez vous :
1) les alias de table ?
2) l'opérateur BETWEEN ?

D'autre part votre WHERE sur le temps annule la branche de jointure externe Vendeur => Devis => temps

Vous devez par exemple écrire...

soit :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
SELECT Vendeurs.id_vendeur, Vendeurs.VendeurInit, Vendeurs.VendeurNom, 
       COUNT(Devis.DevNum) as devs, COUNT(Commandes.CdeNum) as cmds
FROM   Vendeurs AS V
       INNER JOIN Devis AS D 
            ON V.id_vendeur = D.id_vendeur
       LEFT OUTER JOIN CommandesDevis AS CD 
            ON D.id_devis = CD.id_devis
       LEFT OUTER JOIN Commandes AS C 
            ON C.id_commande = CD.id_commande
       INNER JOIN Temps AS T 
            ON D.DevDate = T.id_temps
WHERE  T.id_temps BETWEEN '17899' and '17906'
GROUP  BY V.id_vendeur, V.VendeurInit, V.VendeurNom
ORDER  BY V.id_vendeur

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
SELECT Vendeurs.id_vendeur, Vendeurs.VendeurInit, Vendeurs.VendeurNom, 
       COUNT(Devis.DevNum) as devs, COUNT(Commandes.CdeNum) as cmds
FROM   Vendeurs AS V
       LEFT OUTER JOIN Devis AS D 
            ON V.id_vendeur = D.id_vendeur
       LEFT OUTER JOIN CommandesDevis AS CD 
            ON D.id_devis = CD.id_devis
       LEFT OUTER JOIN Commandes AS C 
            ON C.id_commande = CD.id_commande
       LEFT OUTER JOIN Temps AS T 
            ON D.DevDate = T.id_temps AND T.id_temps BETWEEN '17899' and '17906'
GROUP  BY V.id_vendeur, V.VendeurInit, V.VendeurNom
ORDER  BY V.id_vendeur

Visiblement vous ne maitrisez pas le langage SQL. Je vous invite à vous y former.
Mon livre, comme mon site web, peuvent vous y aider :
http://sqlpro.developpez.com/
Pièce jointe 235564

A +