J'ai un probleme avec une requete UNION qui est la suivante:
SELECT 'DEP' AS Dept,'FAM' AS Famille,'STYLE' AS Style,'WOO' AS
S01WOO0QTE,'WOO' AS S01WOO1SAL,'WOO' AS S01WOO2PRF,'MAD' AS S11MAD0QTE,'MAD'
AS S11MAD1SAL,'MAD' AS S11MAD2PRF,'MIA' AS S18MIA0QTE,'MIA' AS
S18MIA1SAL,'MIA' AS S18MIA2PRF,'STL' AS S20STL0QTE,'STL' AS S20STL1SAL,'STL'
AS S20STL2PRF,'LAM' AS S21LAM0QTE,'LAM' AS S21LAM1SAL,'LAM' AS
S21LAM2PRF,'TOR' AS S40TOR0QTE,'TOR' AS S40TOR1SAL,'TOR' AS S40TOR2PRF,'PAR'
AS S70PAR0QTE,'PAR' AS S70PAR1SAL,'PAR' AS S70PAR2PRF,'TOT' AS
S99TOT0QTE,'TOT' AS S99TOT1SAL,'TOT' AS S99TOT2PRF
ORDER BY Dept, Famille, Style
UNION ALL
SELECT St.Dept, St.Famille, St.Style
,Q.S01WOO0QTE,S.S01WOO1SAL,P.S01WOO2PRF,Q.S11MAD0QTE,S.S11MAD1SAL,P.S11MAD2PRF,Q.S18MIA0QTE,S.S18MIA1SAL,P.S18MIA2PRF,Q.S20STL0QTE,S.S20STL1SAL,P.S20STL2PRF,Q.S21LAM0QTE,S.S21LAM1SAL,P.S21LAM2PRF,Q.S40TOR0QTE,S.S40TOR1SAL,P.S40TOR2PRF,Q.S70PAR0QTE,S.S70PAR1SAL,P.S70PAR2PRF,Q.S99TOT0QTE,S.S99TOT1SAL,P.S99TOT2PRF
FROM ut_RptSalesCumulStyle AS St
LEFT JOIN ut_RptRetailSalesCumulQte AS Q ON St.Style=Q.Style
LEFT JOIN ut_RptRetailSalesCumulSales AS S ON St.Style=S.Style
LEFT JOIN ut_RptRetailSalesCumulProfit AS P ON St.Style=P.Style
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Jean-Nicolas BERGER
Bonsoir, Il faut tout simplement enlever le 'ORDER BY' avant le UNION. Cordialement. JN BERGER
"Julien Bonnier" a écrit dans le message de news:
Bonjours tlm,
J'ai un probleme avec une requete UNION qui est la suivante:
SELECT 'DEP' AS Dept,'FAM' AS Famille,'STYLE' AS Style,'WOO' AS S01WOO0QTE,'WOO' AS S01WOO1SAL,'WOO' AS S01WOO2PRF,'MAD' AS S11MAD0QTE,'MAD' AS S11MAD1SAL,'MAD' AS S11MAD2PRF,'MIA' AS S18MIA0QTE,'MIA' AS S18MIA1SAL,'MIA' AS S18MIA2PRF,'STL' AS S20STL0QTE,'STL' AS S20STL1SAL,'STL' AS S20STL2PRF,'LAM' AS S21LAM0QTE,'LAM' AS S21LAM1SAL,'LAM' AS S21LAM2PRF,'TOR' AS S40TOR0QTE,'TOR' AS S40TOR1SAL,'TOR' AS S40TOR2PRF,'PAR' AS S70PAR0QTE,'PAR' AS S70PAR1SAL,'PAR' AS S70PAR2PRF,'TOT' AS S99TOT0QTE,'TOT' AS S99TOT1SAL,'TOT' AS S99TOT2PRF
ORDER BY Dept, Famille, Style
UNION ALL
SELECT St.Dept, St.Famille, St.Style ,Q.S01WOO0QTE,S.S01WOO1SAL,P.S01WOO2PRF,Q.S11MAD0QTE,S.S11MAD1SAL,P.S11MAD2PRF,Q.S18MIA0QTE,S.S18MIA1SAL,P.S18MIA2PRF,Q.S20STL0QTE,S.S20STL1SAL,P.S20STL2PRF,Q.S21LAM0QTE,S.S21LAM1SAL,P.S21LAM2PRF,Q.S40TOR0QTE,S.S40TOR1SAL,P.S40TOR2PRF,Q.S70PAR0QTE,S.S70PAR1SAL,P.S70PAR2PRF,Q.S99TOT0QTE,S.S99TOT1SAL,P.S99TOT2PRF FROM ut_RptSalesCumulStyle AS St
LEFT JOIN ut_RptRetailSalesCumulQte AS Q ON St.Style=Q.Style
LEFT JOIN ut_RptRetailSalesCumulSales AS S ON St.Style=S.Style
LEFT JOIN ut_RptRetailSalesCumulProfit AS P ON St.Style=P.Style
WHERE Q.S99TOT0QTE IS NOT NULL
ORDER BY St.Dept, St.Famille, St.Style
Elle me retourne :
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'UNION'.
Quelqu'un vois quel est le probleme?
Julien
Bonsoir,
Il faut tout simplement enlever le 'ORDER BY' avant le UNION.
Cordialement.
JN BERGER
"Julien Bonnier" <julien@m0851.com> a écrit dans le message de news:
evM6HJxyHHA.1176@TK2MSFTNGP05.phx.gbl...
Bonjours tlm,
J'ai un probleme avec une requete UNION qui est la suivante:
SELECT 'DEP' AS Dept,'FAM' AS Famille,'STYLE' AS Style,'WOO' AS
S01WOO0QTE,'WOO' AS S01WOO1SAL,'WOO' AS S01WOO2PRF,'MAD' AS
S11MAD0QTE,'MAD' AS S11MAD1SAL,'MAD' AS S11MAD2PRF,'MIA' AS
S18MIA0QTE,'MIA' AS S18MIA1SAL,'MIA' AS S18MIA2PRF,'STL' AS
S20STL0QTE,'STL' AS S20STL1SAL,'STL' AS S20STL2PRF,'LAM' AS
S21LAM0QTE,'LAM' AS S21LAM1SAL,'LAM' AS S21LAM2PRF,'TOR' AS
S40TOR0QTE,'TOR' AS S40TOR1SAL,'TOR' AS S40TOR2PRF,'PAR' AS
S70PAR0QTE,'PAR' AS S70PAR1SAL,'PAR' AS S70PAR2PRF,'TOT' AS
S99TOT0QTE,'TOT' AS S99TOT1SAL,'TOT' AS S99TOT2PRF
ORDER BY Dept, Famille, Style
UNION ALL
SELECT St.Dept, St.Famille, St.Style
,Q.S01WOO0QTE,S.S01WOO1SAL,P.S01WOO2PRF,Q.S11MAD0QTE,S.S11MAD1SAL,P.S11MAD2PRF,Q.S18MIA0QTE,S.S18MIA1SAL,P.S18MIA2PRF,Q.S20STL0QTE,S.S20STL1SAL,P.S20STL2PRF,Q.S21LAM0QTE,S.S21LAM1SAL,P.S21LAM2PRF,Q.S40TOR0QTE,S.S40TOR1SAL,P.S40TOR2PRF,Q.S70PAR0QTE,S.S70PAR1SAL,P.S70PAR2PRF,Q.S99TOT0QTE,S.S99TOT1SAL,P.S99TOT2PRF
FROM ut_RptSalesCumulStyle AS St
LEFT JOIN ut_RptRetailSalesCumulQte AS Q ON St.Style=Q.Style
LEFT JOIN ut_RptRetailSalesCumulSales AS S ON St.Style=S.Style
LEFT JOIN ut_RptRetailSalesCumulProfit AS P ON St.Style=P.Style
Bonsoir, Il faut tout simplement enlever le 'ORDER BY' avant le UNION. Cordialement. JN BERGER
"Julien Bonnier" a écrit dans le message de news:
Bonjours tlm,
J'ai un probleme avec une requete UNION qui est la suivante:
SELECT 'DEP' AS Dept,'FAM' AS Famille,'STYLE' AS Style,'WOO' AS S01WOO0QTE,'WOO' AS S01WOO1SAL,'WOO' AS S01WOO2PRF,'MAD' AS S11MAD0QTE,'MAD' AS S11MAD1SAL,'MAD' AS S11MAD2PRF,'MIA' AS S18MIA0QTE,'MIA' AS S18MIA1SAL,'MIA' AS S18MIA2PRF,'STL' AS S20STL0QTE,'STL' AS S20STL1SAL,'STL' AS S20STL2PRF,'LAM' AS S21LAM0QTE,'LAM' AS S21LAM1SAL,'LAM' AS S21LAM2PRF,'TOR' AS S40TOR0QTE,'TOR' AS S40TOR1SAL,'TOR' AS S40TOR2PRF,'PAR' AS S70PAR0QTE,'PAR' AS S70PAR1SAL,'PAR' AS S70PAR2PRF,'TOT' AS S99TOT0QTE,'TOT' AS S99TOT1SAL,'TOT' AS S99TOT2PRF
ORDER BY Dept, Famille, Style
UNION ALL
SELECT St.Dept, St.Famille, St.Style ,Q.S01WOO0QTE,S.S01WOO1SAL,P.S01WOO2PRF,Q.S11MAD0QTE,S.S11MAD1SAL,P.S11MAD2PRF,Q.S18MIA0QTE,S.S18MIA1SAL,P.S18MIA2PRF,Q.S20STL0QTE,S.S20STL1SAL,P.S20STL2PRF,Q.S21LAM0QTE,S.S21LAM1SAL,P.S21LAM2PRF,Q.S40TOR0QTE,S.S40TOR1SAL,P.S40TOR2PRF,Q.S70PAR0QTE,S.S70PAR1SAL,P.S70PAR2PRF,Q.S99TOT0QTE,S.S99TOT1SAL,P.S99TOT2PRF FROM ut_RptSalesCumulStyle AS St
LEFT JOIN ut_RptRetailSalesCumulQte AS Q ON St.Style=Q.Style
LEFT JOIN ut_RptRetailSalesCumulSales AS S ON St.Style=S.Style
LEFT JOIN ut_RptRetailSalesCumulProfit AS P ON St.Style=P.Style