Erreur req. SQL listleft pgm VIEW_COLLECTION : ASA Error -143: Column 'SERIE_ALPHA_UK' not found
SELECT DISTINCT TOP 30 O.OUVRAGE_NUMERO AS OUVRAGE_NUMERO, S.SERIE_NAME_EN AS SERIE_NAME, A.LCOUJPGV AS LCOUJPGV, A.LCOUJPGG AS LCOUJPGG, O.OUVRAGE_NAME_EN AS OUVRAGE_NAME, O.OUVRAGE_ID AS OUVRAGE_ID, A.NART AS NART, DATEFORMAT(P.DDEBSITCOM,'YYYYMMDD') AS DATETEST, P.DDEBSITCOM AS DDEBSITCOM,(sin(OUVRAGE_ID * rand())) as Rd FROM DBA.VIEW_ARTICLES_UK A, DBA.VIEW_OUVRAGES O, DBA.CAT_PARUTIONS P, DBA.VIEW_SERIES S WHERE S.SERIE_ID=O.OUVRAGE_SERIE_ID AND S.SERIE_ALPHA_UK LIKE 'a%' AND S.SERIE_COLLECTION_ID=5 AND O.OUVRAGE_ID=A.OUVRAGE_ID AND A.NART=P.NART AND LCOUJPGV<>'' AND LCOUJPGG<>'' AND P.DDEBSITCOM <= (SELECT STRING((SELECT YEAR(MONTHS(GETDATE(),1))),'-',(SELECT MONTH(MONTHS(GETDATE(),1))),'-','01')) ORDER BY P.DDEBSITCOM DESC,Rd
Dupuis
