SELECT DISTINCT CLIENT.NomCli, CLIENT.AdrCli, CLIENT.CPCli, CLIENT.VilleCli, Expedier.NbPal, Expedier.NbCol, Expedier.NbLong, Expedier.NomTrans, Expedier.Kgs, Expedier.NoBL, Expedier.NoRecipissé
FROM CLIENT INNER JOIN Expedier ON CLIENT.NoCli = Expedier.NoCli
GROUP BY CLIENT.NomCli, CLIENT.AdrCli, CLIENT.CPCli, CLIENT.VilleCli, Expedier.DateExp, Expedier.NbPal, Expedier.NbCol, Expedier.NbLong, Expedier.NomTrans, Expedier.Kgs, Expedier.NoBL, Expedier.NoRecipissé
HAVING (((Expedier.DateExp)=[Entrez la date d'expédition recherchée ?]))
ORDER BY CLIENT.NomCli;
Partager