modèles/Facture.Totaux.sql

   1 \p modèles/Facture.Totaux.sql
   2 SELECT
   3   ID,
   4   SUM(ROUND(quantité,2) * euros) as prix_total
   5   FROM "Factures"
   6   GROUP BY ID
   7 ;
   8 select * from "Factures";
   9 SELECT "Prod".nom_complet
  10      , SUM(ROUND(quantité,2) * euros) as prix_total
  11   FROM "Factures"
  12   JOIN TABLE (choisirUnProduit()) AS "Prod" ON "Prod".ID = produit
  13   WHERE "ID" = '1'
  14   GROUP BY ID, "Prod".nom_complet
  15 ;