jointure php mysql avec trois tables
Posted by:
met moo
Date: August 07, 2024 03:10PM
Bonjour, j'avais un souci j'ai tout fais mais j'arrive pas à resoudre
J'ai trois tables:
table1 article: id, nom_article, categorie_article, quantite_article, `prix_unitaire`
table2 client: id, nom, prenom
table qui va contient: id, id_article, id_client, quantite, prix date_vente
malheureusement quand j'essaye de faire la jointure des tables article - client
dans table vente le resultat me revient vide:
SELECT quantite, prix, date_vente FROM vente JOIN article ON vente.id_article =article.id INNER JOIN client ON vente.id_client = client.id
Merci de votre aide
Subject
Views
Written By
Posted
jointure php mysql avec trois tables
204
August 07, 2024 03:10PM
82
August 20, 2024 05:09AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.