1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SELECT
Ecritures.IDEcritures AS IDEcritures,
Ecritures.Type_ecriture AS Type_ecriture,
Ecritures.CLT_doss AS CLT_doss,
Ecritures.Date AS DATE,
Ecritures.Quant AS Quant,
Ecritures.PRIX_V AS PRIX_V,
Ecritures.Code_frais AS Code_frais,
Ecritures.Forfait_Except AS Forfait_Except,
Ecritures.Etat_Facturation AS Etat_Facturation,
FRAIS.Soumis_a_TVA AS Soumis_a_TVA,
Ecritures.TEMPS AS TEMPS
FROM
FRAIS RIGHT OUTER JOIN Ecritures ON Ecritures.Code_frais = FRAIS.Code_frais
WHERE
(
Ecritures.Date <= {ParamDate}
AND Ecritures.Etat_Facturation = ''
)
ORDER BY
CLT_doss ASC |
Partager