SELECT DISTINCT FACTURES.NO_COMMANDE, FACTURES.ANNEE, LIGNFACT.
CODEVAR,
LIGNFACT.Q_COM, VARIET.NOM, VARIET.REM,
FICENT.CODE, FICENT.NOM,FICENT.ADRESSE_1, FICENT.ADRESSE_2,
FICENT.CODE_POSTAL, FICENT.VILLE,
FICENT.PAYS, FICENT.SOCIETE, FICENT.SIRET, FICENT.APE,
FICENT.REGISTRE_DU_COMMERCE, FICENT.TVA_CEE,
FICENT.TEL, FICENT.FAX, FICENT.BANQUE, FICENT.NO_COMPTE, FICENT.CCP,
FICENT.APV,
FICENT.EMAIL,REPRESENTANTS.NOM, CLIENTS.NO_CLIENT, CLIENTS.INTITULE,
CLIENTS.NOM, CLIENTS.ADRESSE_1,
CLIENTS.ADRESSE_2, CLIENTS.CODE_POSTAL, CLIENTS.VILLE, CLIENTS.PAYS,
CLIENTS.NOM1, CLIENTS.AD1, CLIENTS.AD2,
CLIENTS.CPOST, CLIENTS.VILLE1, LIGNFACT.Q_LIV, LIGNFACT.P100,
LIGNFACT.TOTAL, FACTURES.DATE_COMMANDE,
FACTURES.SEMAINE, FACTURES.SEM, FACTURES.TOTSEM, FACTURES.QUANTITE,
FACTURES.PRIX, FACTURES.TRANSPORT,
FACTURES.MODE_RGLT
FROM FACTURES
   INNER JOIN LIGNFACT ON (FACTURES.NO_LIGNE = LIGNFACT.NOCOM)
   INNER JOIN VARIET ON (LIGNFACT.CODEVAR = VARIET.CODEVAR)
   INNER JOIN ANNEE ON (FACTURES.ANNEE = ANNEE.ANNEE)
   INNER JOIN CLIENTS ON (FACTURES.NO_CLIENT = CLIENTS.NO_CLIENT)
   INNER JOIN REPRESENTANTS ON (FACTURES.REPRESENTANT = REPRESENTANTS.
CODE)
   INNER JOIN FICENT ON (FACTURES.CODE_ENTREPRISE = FICENT.CODE)
WHERE
   (
      (FACTURES.NO_COMMANDE = 10)
   )