Re: [users-fr] prob sous requête SQL oo base

Sun, 19 Mar 2006 15:18:12 -0800 

Il semble que mes deux messages précédents aient subi un formatage
curieux. Voici les bonnes versions :

(avec WHERE)

SELECT * FROM

( SELECT "AR_Ref", "A déprécier" FROM "DonneesGilles" WHERE "A
déprécier" LIKE 'X' ) "A",

( SELECT "CodeArticle", "Designation", SUM( "Quantité" ) AS
"SumQuantite", "Unite", "PrixUnitMoy", "SuiviStock", SUM( "Montant" )
AS "SumMontant" FROM "DonneesInventaire" "DonneesInventaire" GROUP BY
"CodeArticle", "Designation", "Unite", "PrixUnitMoy", "SuiviStock"
ORDER BY "CodeArticle" ASC ) "B"

WHERE "A"."AR_Ref" = "B"."CodeArticle"

(et avec INNER JOIN)

SELECT * FROM

( SELECT "AR_Ref", "A déprécier" FROM "DonneesGilles" WHERE "A
déprécier" LIKE 'X' ) "A"

INNER JOIN

( SELECT "CodeArticle", "Designation", SUM( "Quantité" ) AS
"SumQuantite", "Unite", "PrixUnitMoy", "SuiviStock", SUM( "Montant" )
AS "SumMontant" FROM "DonneesInventaire" "DonneesInventaire" GROUP BY
"CodeArticle", "Designation", "Unite", "PrixUnitMoy", "SuiviStock"
ORDER BY "CodeArticle" ASC ) "B"

ON "A"."AR_Ref" = "B"."CodeArticle"

Bon, je vais au dodo.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Répondre à