Merci pour vos retours.
La 1 méthode
La 2 méthodeCode (Text):
SELECT
CLIENT.COD_CLI AS COD_CLI,
CLIENT.RAIS_CLI AS RAIS_CLI,
FROM CLIENT
LEFT OUTER JOIN FACTURE
ON CLIENT.COD_CLI=FACTURE.COD_CLI AND
(
FACTURE.DATE_FAC BETWEEN {Param1} AND {Param2}
)
WHERE FACTURE.COD_CLI IS NULL
AND CLIENT.COD_REP= {Param3}
La 2ème méthode est plus rapide que la 1Code (Text):
SELECT
CLIENT.COD_CLI AS COD_CLI,
CLIENT.RAIS_CLI AS RAIS_CLI,
FROM CLIENT
WHERE
CLIENT.COD_REP = {sParamCOD_REP}
AND CLIENT.COD_CLI NOT IN
(
SELECT DISTINCT
FACTURE.COD_CLI AS COD_CLI
FROM
FACTURE
WHERE
FACTURE.DATE_FAC BETWEEN {sParamDATE_DEB} AND {sParamDATE_FIN}
)
Chargement...