Erreur SQL ! SELECT articles.Photo,articles.LibelleCourt,articles.infos, articles.LibelleLong, promotions.codeArticle, if(promotions.codetaille is null,'TOUTES LES TAILLES',promotions.codetaille) AS TAILLE, IF(promotions.codecouleur IS NULL,'TOUTES LES COULEURS',promotions.codecouleur) AS COULEUR,if(grillescouleurs.Code is null,'',grillescouleurs.image) AS coulPhoto ,promotions.Motif AS Descrip, DATE_FORMAT(promotions.Date1, '%d/%m/%Y') AS DateDeb, DATE_FORMAT(promotions.Date2, '%d/%m/%Y') AS DateFin, round(promotions.TauxRemise,2) AS REMISE,IF(promotions.codeCaisse is null,'dans tous nos points de vente',concat('au point de vente ',caisses.Libelle,' uniquement.')) As caisselib FROM promotions LEFT OUTER JOIN articles ON (promotions.codeArticle = articles.Code OR (promotions.codeArticle IS NULL AND promotions.codeFamille IS NULL) OR (promotions.codeFamille = articles.codeFamille)) LEFT OUTER JOIN grillescouleurs ON (grillescouleurs.code=promotions.codeCouleur) LEFT OUTER JOIN caisses ON (caisses.code=promotions.codeCaisse) WHERE (articles.bWeb = 1) AND (Bloque=0) AND (promotions.Date1 <= Now()) AND (promotions.Date2 >= Now()) Unknown column 'caisses.Libelle' in 'field list'
