JOIN
Relie deux tables.
Syntaxe
SELECT ... FROM a JOIN b ON a.id = b.a_id;
Exemple
SELECT c.nom, v.montant FROM clients c JOIN ventes v ON v.client_id = c.id;
Se former au numérique
JOINRelie deux tables.
SELECT ... FROM a JOIN b ON a.id = b.a_id;
SELECT c.nom, v.montant FROM clients c JOIN ventes v ON v.client_id = c.id;