doublons en sql |
Sujet: doublons en sql par Anonyme sur 1/3/2006 16:12:12 ch_sql1 =" SELECT FACT_DETAIL.idsal_fdetail, "//1 Ch_sql1 +=" FACT_DETAIL.Numfacture_fdetail,"//2 ch_sql1 +=" FACT_DETAIL.codeart_fdetail,"//3 ch_sql1 +=" FACT_DETAIL.libelle_fdetail, " //4 ch_sql1 +=" FACT_DETAIL.totalavecremise_fdetail, "//5 ch_sql1 +=" FACT_DETAIL.codeoperateur, "//6 ch_sql1 +=" FACT_DETAIL.nomcli_fdetail, "//7 ch_sql1 +=" FACTURE.modeenc_fact, "//8 ch_sql1 +=" FACTURE.montantp_fact, " //9 ch_sql1 +=" FACTURE.montantv_fact, " //10 ch_sql1 +=" FACTURE.impaye_fact, " //11 ch_sql1 +=" FACTURE.espece_fact, " //12 ch_sql1 +=" FACTURE.cheque_fact, " //13 ch_sql1 +=" FACTURE.carte_fact, " //14 ch_sql1 +=" FACTURE.moneo_fact, " //15 ch_sql1 +=" FACTURE.autre_fact, " //16 ch_sql1 +=" FACTURE.num_fact " Ch_sql1 +=" FROM FACT_DETAIL, FACTURE" Ch_sql1 +=" WHERE FACT_DETAIL.Numfacture_fdetail = FACTURE.num_fact " Ch_sql1 +=" AND FACTURE.date_fact = '"+d_jour+"' " Bonjour ! plus haut c'est la requete que je fais mais elle me renvoie les résultat avec des doublons ? comment enlever ses doublons ? merci |