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
436
August 07, 2024 03:10PM
191
August 20, 2024 05:09AM
Sorry, you can't reply to this topic. It has been closed.
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.