1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SELECT noteFrais.numNote AS numNote,
frais.numFrais AS numFrais,
frais.dateFrais AS dateFrais,
frais.libelle AS libelle ,
frais.montantHT AS montantHT,
frais.montantTVA AS montantTVA,
frais.montantTTC AS montantTTC,
projet.nomProjet AS nomProjet,
TVA.tauxTVA AS tauxTVA,
nomIntervenant AS Intervenant,
client.nomClient AS nomClient,
client.numClient AS numClient
FROM frais
INNER JOIN noteFrais ON (frais.numNote = noteFrais.numNote)
INNER JOIN intervenant ON(noteFrais.numIntervenant=intervenant.numIntervenant)
INNER JOIN TVA ON (frais.numTVA = TVA.numTauxTVA)
INNER JOIN projet ON (noteFrais.numProjet = projet.numProjet)
INNER JOIN client on (projet.numClient = client.numClient)
WHERE aRefacturer=1 AND client.numClient=2 |
Partager