1 2 3 4 5 6 7 8 9
| SELECT cmd_id, cmd.prd_id, cmd_url, cmd_quantite, cmd_px_total, cmd_freeshipping, DATE_FORMAT(cmd_date,'%d/%m/%y') AS cmd_date, DATE_FORMAT(cmd_date_livraison,'%d/%m/%y') AS cmd_date_livraison,
prd.prd_id, prd.sscat_id, prd.cat_id, prd_nom, prd_poids, prd_colis2cm, prd_suspend,
sscat.sscat_id, sscat_nom,
cat.cat_id, cat_nom
FROM commandes AS cmd
INNER JOIN produits AS prd ON cmd.prd_id = prd.prd_id
INNER JOIN sscategories AS sscat ON prd.sscat_id = sscat.sscat_id
INNER JOIN categories AS cat ON prd.cat_id = cat.cat_id
ORDER BY cat_nom, sscat_nom, prd_nom ASC |
Partager