1 2 3 4 5
| SELECT entite.idEntite, entite.parametreEnt, parametre_2.parametreInt AS quantite, parametre_1.parametreDec AS tarif, parametre.parametreInt AS reference, base.libelleBase AS couleur, Round([quantite]*[tarif],2) AS total, entite.dateEntite, base_2.parametreBaseTxt AS groupe, base_2.libelleBase AS groupe_libelle, base_1.libelleBase AS modele, base_3.libelleBase AS textile, entite_1.idEntite AS idProduit, critere.idBase AS idCouleur
FROM (((entite INNER JOIN parametre AS parametre_2 ON entite.idEntite = parametre_2.idEntite) INNER JOIN (base AS base_3 RIGHT JOIN (((base AS base_1 LEFT JOIN base AS base_2 ON base_1.parametreBaseInt = base_2.idBase) RIGHT JOIN ((parametre LEFT JOIN entite AS entite_1 ON parametre.parametreInt = entite_1.idEntite) LEFT JOIN critere AS critere_1 ON entite_1.idEntite = critere_1.idEntite) ON base_1.idBase = critere_1.idBase) LEFT JOIN critere AS critere_2 ON entite_1.idEntite = critere_2.idEntite) ON base_3.idBase = critere_2.idBase) ON entite.idEntite = parametre.idEntite) LEFT JOIN (base RIGHT JOIN critere ON base.idBase = critere.idBase) ON entite.idEntite = critere.idEntite) LEFT JOIN parametre AS parametre_1 ON entite.idEntite = parametre_1.idEntite
WHERE (((entite.idEntiteType)=5) AND ((parametre.idParamType)=27) AND ((parametre_2.idParamType)=28) AND ((parametre_1.idParamType)=29) AND ((critere.idRubrique)=3 Or (critere.idRubrique) Is Null) AND ((nz([critere_1].[idRubrique],2))=2) AND ((nz([critere_2].[idRubrique],1))=1)); |
Partager