1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| SELECT
BORDEREAU.NUMBE AS NUMBE,
BORDEREAU.DATEBE AS DATEBE,
CLIENT.NOMCLIENT AS NOMCLIENT,
ligneCde.des_be AS des_be,
ligneCde.Nombre AS Nombre,
ligneCde.Observations AS Observations,
ligneCde.OrdreAffichage AS OrdreAffichage,
forme.Code_DOC AS Code_DOC,
forme.Version AS Version,
forme.Logo AS Logo,
forme.enete_Ligne_1 AS enete_Ligne_1,
forme.Adresse AS Adresse,
forme.Téléphone AS Téléphone,
forme.Email AS Email,
forme.code_be AS code_be,
forme.Strecture AS Strecture,
forme.pied_page AS pied_page
FROM
BORDEREAU,
ligneCde,
CLIENT,
forme
WHERE
CLIENT.NOMCLIENT = BORDEREAU.NomClient
AND BORDEREAU.IDbE = ligneCde.IDbE
AND
(
BORDEREAU.NUMBE BETWEEN {Param1} AND {Param2}
)
ORDER BY
NUMBE ASC |
Partager