You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
422 B
20 lines
422 B
2 years ago
|
-- Query 11
|
||
|
|
|
||
|
|
SELECT
|
||
|
|
facture.numfacture,
|
||
|
|
facture.numtable,
|
||
|
|
tables.nomtable
|
||
|
|
FROM facture
|
||
|
|
INNER JOIN serveur ON serveur.numserveur = facture.numserveur
|
||
|
|
INNER JOIN tables ON tables.numtable = facture.numtable
|
||
|
|
WHERE
|
||
|
|
facture.datefacture = "20060222"
|
||
|
|
AND serveur.nomserveur = "Martin Cathy"
|
||
|
|
ORDER BY facture.numtable;
|
||
|
|
|
||
|
|
/* == RESULT ==
|
||
|
|
"numfacture","numtable","nomtable"
|
||
|
|
1206,3,"Fenetre1"
|
||
|
|
1204,4,"Fenetre2"
|
||
|
|
*/
|