1 2 3 4 5
| SELECT com_datepassage, com_statut, mar_nom, tiers_nom, sum((quantite*article_prix)*(1+(art_tva/100))), contient.com_id
FROM ( select com_datepassage, com_statut, mar_nom, tiers_nom, commande.com_id from commande, marches, tiers where commande.mar_numsedit=marches.mar_numsedit AND marches.tiers_numsedit = tiers.tiers_numsedit) r1
JOIN
( select sum((quantite*article_prix)*(1+(art_tva/100))), commande.com_id from contient, article, commande where contient.article_id=article.article_id AND commande.com_id=contient.com_id GROUP BY commande.com_id) r2
ON r1.com_id = r2.com_id; |