iparmenioni | salut j'ai essayé avec union mais j'ai une erreur sql:
Code :
- SELECT count(cs.num_cheque) AS nbr_cheque, cs.montant_cheque, YEAR(date_facturation) AS annee, MONTH(date_facturation) AS mois , SUM(CASE WHEN id_cheque_sport_statut = 2 THEN 1 ELSE 0 END ) as nb_vendu
-
- FROM cheque_sport AS cs
- WHERE cs.is_utilise = -1
- AND date_facturation > DATE_ADD(now(), Interval -2 year)
- UNION
- SELECT count(cs.num_cheque) AS cheque_vendu, cs.montant_cheque, YEAR(date_facturation) AS annee, MONTH(date_facturation) AS mois , SUM(CASE WHEN id_cheque_sport_statut = 2 THEN 1 ELSE 0 END ) as nb_vendu
- FROM cheque_sport AS cs
- WHERE date_facturation > DATE_ADD(now(), Interval -2 year)
- GROUP BY YEAR(date_facturation), MONTH(date_facturation)
- ORDER BY YEAR(date_facturation);
|
Elle fonctionne sans le group et le orderby mais pas avec. Comment faire? merci |