SELECT [ANNUEL_FACTURE].[ID] AS [ID], [ANNUEL_FACTURE].[PERIODE] AS [PERIODE], [ANNUEL_FACTURE].[MONTANT_ANNUEL] AS [MONTANT_ANNUEL] FROM [dbo].[ANNUEL_FACTURE] AS [ANNUEL_FACTURE] SELECT [CLI_ANNUEL_VALID].[ID] AS [ID], [CLI_ANNUEL_VALID].[PERIODE] AS [PERIODE], [CLI_ANNUEL_VALID].[Montant] AS [Montant] FROM [dbo].[CLI_ANNUEL_VALID] AS [CLI_ANNUEL_VALID] SELECT [COTISATION_80_ANNEE].[ID] AS [ID], [COTISATION_80_ANNEE].[PERIODE] AS [PERIODE], [COTISATION_80_ANNEE].[MONTANT] AS [MONTANT] FROM [dbo].[COTISATION_80_ANNEE] AS [COTISATION_80_ANNEE] SELECT [COTISATION_80_MOIS].[ID] AS [ID], [COTISATION_80_MOIS].[PERIODE] AS [PERIODE], [COTISATION_80_MOIS].[MONTANT] AS [MONTANT] FROM [dbo].[COTISATION_80_MOIS] AS [COTISATION_80_MOIS] SELECT [COTISATION_90_ANNEE].[ID] AS [ID], [COTISATION_90_ANNEE].[PERIODE] AS [PERIODE], [COTISATION_90_ANNEE].[MONTANT] AS [MONTANT] FROM [dbo].[COTISATION_90_ANNEE] AS [COTISATION_90_ANNEE] SELECT [COTISATION_90_MOIS].[ID] AS [ID], [COTISATION_90_MOIS].[PERIODE] AS [PERIODE], [COTISATION_90_MOIS].[MONTANT] AS [MONTANT] FROM [dbo].[COTISATION_90_MOIS] AS [COTISATION_90_MOIS] SELECT [COTISATION_ANNEE].[ID] AS [ID], [COTISATION_ANNEE].[PERIODE] AS [PERIODE], [COTISATION_ANNEE].[Montant] AS [Montant] FROM [dbo].[COTISATION_ANNEE] AS [COTISATION_ANNEE] SELECT [COTISATION_MOIS].[ID] AS [ID], [COTISATION_MOIS].[PERIODE] AS [PERIODE], [COTISATION_MOIS].[Montant] AS [Montant] FROM [dbo].[COTISATION_MOIS] AS [COTISATION_MOIS] SELECT [MONT_FACT_CLI].[ID] AS [ID], [MONT_FACT_CLI].[PERIODE] AS [PERIODE], [MONT_FACT_CLI].[Montant] AS [Montant] FROM [dbo].[MONT_FACT_CLI] AS [MONT_FACT_CLI] SELECT [MONT_FACT_PHAR].[ID] AS [ID], [MONT_FACT_PHAR].[PERIODE] AS [PERIODE], [MONT_FACT_PHAR].[MONTANT] AS [MONTANT] FROM [dbo].[MONT_FACT_PHAR] AS [MONT_FACT_PHAR] SELECT [MONT_VALID_FACTCLI_MOIS].[ID] AS [ID], [MONT_VALID_FACTCLI_MOIS].[PERIODE] AS [PERIODE], [MONT_VALID_FACTCLI_MOIS].[Montant] AS [Montant] FROM [dbo].[MONT_VALID_FACTCLI_MOIS] AS [MONT_VALID_FACTCLI_MOIS] SELECT [MONT_VALID_FACTPHAR_MOIS].[ID] AS [ID], [MONT_VALID_FACTPHAR_MOIS].[PERIODE] AS [PERIODE], [MONT_VALID_FACTPHAR_MOIS].[Montant] AS [Montant] FROM [dbo].[MONT_VALID_FACTPHAR_MOIS] AS [MONT_VALID_FACTPHAR_MOIS] SELECT [MONTANT_ANNUEL_CLI].[ID] AS [ID], [MONTANT_ANNUEL_CLI].[PERIODE] AS [PERIODE], [MONTANT_ANNUEL_CLI].[Montant] AS [Montant] FROM [dbo].[MONTANT_ANNUEL_CLI] AS [MONTANT_ANNUEL_CLI] SELECT [MONTANT_ANNUEL_PHAR].[ID] AS [ID], [MONTANT_ANNUEL_PHAR].[PERIODE] AS [PERIODE], [MONTANT_ANNUEL_PHAR].[MONTANT] AS [MONTANT] FROM [dbo].[MONTANT_ANNUEL_PHAR] AS [MONTANT_ANNUEL_PHAR] SELECT [PHAR_ANNUEL_VALID].[ID] AS [ID], [PHAR_ANNUEL_VALID].[PERIODE] AS [PERIODE], [PHAR_ANNUEL_VALID].[MONTANT] AS [MONTANT] FROM [dbo].[PHAR_ANNUEL_VALID] AS [PHAR_ANNUEL_VALID] SELECT [REMBOURSEMENT_ANNEE].[ID] AS [ID], [REMBOURSEMENT_ANNEE].[PERIODE] AS [PERIODE], [REMBOURSEMENT_ANNEE].[Montant] AS [Montant] FROM [dbo].[REMBOURSEMENT_ANNEE] AS [REMBOURSEMENT_ANNEE] SELECT [REMBOURSEMENT_MOIS].[ID] AS [ID], [REMBOURSEMENT_MOIS].[PERIODE] AS [PERIODE], [REMBOURSEMENT_MOIS].[Montant] AS [Montant] FROM [dbo].[REMBOURSEMENT_MOIS] AS [REMBOURSEMENT_MOIS] SELECT [STAT_GENERALES].[LIBELLE_CATEGORIE_PROFESSIONELLE] AS [LIBELLE_CATEGORIE_PROFESSIONELLE], [STAT_GENERALES].[FACTURE_RECUES] AS [FACTURE_RECUES], [STAT_GENERALES].[PART_ASSURANCE] AS [PART_ASSURANCE], [STAT_GENERALES].[LIBELLE_TYPE_ASSURE] AS [LIBELLE_TYPE_ASSURE], [STAT_GENERALES].[NOMBRE] AS [NOMBRE] FROM [dbo].[STAT_GENERALES] AS [STAT_GENERALES] SELECT [SYNTHESEFACTURECLINIQUE].[CATEGORIE] AS [CATEGORIE], [SYNTHESEFACTURECLINIQUE].[ACTE] AS [ACTE], [SYNTHESEFACTURECLINIQUE].[FACTURES_VALIDEES] AS [FACTURES_VALIDEES], [SYNTHESEFACTURECLINIQUE].[CONSOMMATION_REELLE] AS [CONSOMMATION_REELLE], [SYNTHESEFACTURECLINIQUE].[ANNEE] AS [ANNEE], [SYNTHESEFACTURECLINIQUE].[MOIS] AS [MOIS], [SYNTHESEFACTURECLINIQUE].[JOUR] AS [JOUR] FROM [dbo].[SYNTHESEFACTURECLINIQUE] AS [SYNTHESEFACTURECLINIQUE] SELECT [View_Consommationannuel].[id] AS [id], [View_Consommationannuel].[ANNEE] AS [ANNEE], [View_Consommationannuel].[MOIS] AS [MOIS], [View_Consommationannuel].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_Consommationannuel].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_Consommationannuel].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_Consommationannuel].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_Consommationannuel] AS [View_Consommationannuel] SELECT [View_DEPENSES_MOIS_FAMILLE].[ANNEE] AS [ANNEE], [View_DEPENSES_MOIS_FAMILLE].[MOIS] AS [MOIS], [View_DEPENSES_MOIS_FAMILLE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_DEPENSES_MOIS_FAMILLE].[REFERENCE_ADHERENT] AS [REFERENCE_ADHERENT], [View_DEPENSES_MOIS_FAMILLE].[NOMS_ET_PRENOMS] AS [NOMS_ET_PRENOMS], [View_DEPENSES_MOIS_FAMILLE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSES_MOIS_FAMILLE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSES_MOIS_FAMILLE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSES_MOIS_FAMILLE] AS [View_DEPENSES_MOIS_FAMILLE] SELECT [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[ANNEE] AS [ANNEE], [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[MOIS] AS [MOIS], [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[REFERENCE_ADHERENT] AS [REFERENCE_ADHERENT], [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[NOMS_ET_PRENOMS] AS [NOMS_ET_PRENOMS], [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSES_MOIS_FAMILLE_CLINIQUE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSES_MOIS_FAMILLE_CLINIQUE] AS [View_DEPENSES_MOIS_FAMILLE_CLINIQUE] SELECT [View_DEPENSES_MOIS_FAMILLE_GROUP].[ID] AS [ID], [View_DEPENSES_MOIS_FAMILLE_GROUP].[ANNEE] AS [ANNEE], [View_DEPENSES_MOIS_FAMILLE_GROUP].[MOIS] AS [MOIS], [View_DEPENSES_MOIS_FAMILLE_GROUP].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_DEPENSES_MOIS_FAMILLE_GROUP].[REFERENCE_ADHERENT] AS [REFERENCE_ADHERENT], [View_DEPENSES_MOIS_FAMILLE_GROUP].[NOMS_ET_PRENOMS] AS [NOMS_ET_PRENOMS], [View_DEPENSES_MOIS_FAMILLE_GROUP].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSES_MOIS_FAMILLE_GROUP].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSES_MOIS_FAMILLE_GROUP].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSES_MOIS_FAMILLE_GROUP] AS [View_DEPENSES_MOIS_FAMILLE_GROUP] SELECT [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[ANNEE] AS [ANNEE], [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[MOIS] AS [MOIS], [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[REFERENCE_ADHERENT] AS [REFERENCE_ADHERENT], [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[NOMS_ET_PRENOMS] AS [NOMS_ET_PRENOMS], [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSES_MOIS_FAMILLE_PHARMACIE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSES_MOIS_FAMILLE_PHARMACIE] AS [View_DEPENSES_MOIS_FAMILLE_PHARMACIE] SELECT [View_DEPENSESCLINIQUE_ANNEE].[ID] AS [ID], [View_DEPENSESCLINIQUE_ANNEE].[ANNEE] AS [ANNEE], [View_DEPENSESCLINIQUE_ANNEE].[NOM_ETABLISSEMENT] AS [NOM_ETABLISSEMENT], [View_DEPENSESCLINIQUE_ANNEE].[NOMBRE] AS [NOMBRE], [View_DEPENSESCLINIQUE_ANNEE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSESCLINIQUE_ANNEE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSESCLINIQUE_ANNEE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSESCLINIQUE_ANNEE] AS [View_DEPENSESCLINIQUE_ANNEE] SELECT [View_DEPENSESCLINIQUE_MOIS_ANNEE].[ID] AS [ID], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[ANNEE] AS [ANNEE], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[MOIS] AS [MOIS], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[NOM_ETABLISSEMENT] AS [NOM_ETABLISSEMENT], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[NOMBRE] AS [NOMBRE], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSESCLINIQUE_MOIS_ANNEE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSESCLINIQUE_MOIS_ANNEE] AS [View_DEPENSESCLINIQUE_MOIS_ANNEE] SELECT [View_DEPENSESPHARMACIE_ANNEE].[ID] AS [ID], [View_DEPENSESPHARMACIE_ANNEE].[ANNEE] AS [ANNEE], [View_DEPENSESPHARMACIE_ANNEE].[NOM_ETABLISSEMENT] AS [NOM_ETABLISSEMENT], [View_DEPENSESPHARMACIE_ANNEE].[NOMBRE] AS [NOMBRE], [View_DEPENSESPHARMACIE_ANNEE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSESPHARMACIE_ANNEE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSESPHARMACIE_ANNEE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSESPHARMACIE_ANNEE] AS [View_DEPENSESPHARMACIE_ANNEE] SELECT [View_DEPENSESPHARMACIE_MOIS_ANNEE].[ID] AS [ID], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[ANNEE] AS [ANNEE], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[MOIS] AS [MOIS], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[RAISONSOCIALE] AS [RAISONSOCIALE], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[NOMBRE] AS [NOMBRE], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_DEPENSESPHARMACIE_MOIS_ANNEE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_DEPENSESPHARMACIE_MOIS_ANNEE] AS [View_DEPENSESPHARMACIE_MOIS_ANNEE] SELECT [View_ENCAISSEMENTSASSURE].[ID] AS [ID], [View_ENCAISSEMENTSASSURE].[ANNEE] AS [ANNEE], [View_ENCAISSEMENTSASSURE].[MOIS] AS [MOIS], [View_ENCAISSEMENTSASSURE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_ENCAISSEMENTSASSURE].[LIBELLE_CATEGORIE_PROFESSIONELLE] AS [LIBELLE_CATEGORIE_PROFESSIONELLE], [View_ENCAISSEMENTSASSURE].[MONTANT] AS [MONTANT] FROM [dbo].[View_ENCAISSEMENTSASSURE] AS [View_ENCAISSEMENTSASSURE] SELECT [VIEW_FACTURE_PAR_PERIODE].[ANNEE] AS [ANNEE], [VIEW_FACTURE_PAR_PERIODE].[PERIODE] AS [PERIODE], [VIEW_FACTURE_PAR_PERIODE].[MONTANT ORIGINE] AS [MONTANT ORIGINE], [VIEW_FACTURE_PAR_PERIODE].[TAUX] AS [TAUX], [VIEW_FACTURE_PAR_PERIODE].[MOIS] AS [MOIS], [VIEW_FACTURE_PAR_PERIODE].[MONTANT VALIDER] AS [MONTANT VALIDER], [VIEW_FACTURE_PAR_PERIODE].[PART LDFG] AS [PART LDFG], [VIEW_FACTURE_PAR_PERIODE].[PART ASSURE] AS [PART ASSURE] FROM [dbo].[VIEW_FACTURE_PAR_PERIODE] AS [VIEW_FACTURE_PAR_PERIODE] SELECT [View_MONTANT_FACTURE].[ANNEE] AS [ANNEE], [View_MONTANT_FACTURE].[MOIS] AS [MOIS], [View_MONTANT_FACTURE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_MONTANT_FACTURE].[MONTANTVALIDER] AS [MONTANTVALIDER], [View_MONTANT_FACTURE].[MONTANTORIGINE] AS [MONTANTORIGINE], [View_MONTANT_FACTURE].[MONTANTLDF] AS [MONTANTLDF] FROM [dbo].[View_MONTANT_FACTURE] AS [View_MONTANT_FACTURE] SELECT [View_STATFACTCLINIQUE].[ANNEE] AS [ANNEE], [View_STATFACTCLINIQUE].[MOIS] AS [MOIS], [View_STATFACTCLINIQUE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_STATFACTCLINIQUE].[CATEGORIE_PROFESSIONELLE] AS [CATEGORIE_PROFESSIONELLE], [View_STATFACTCLINIQUE].[STATUTS] AS [STATUTS], [View_STATFACTCLINIQUE].[NOMBRE] AS [NOMBRE], [View_STATFACTCLINIQUE].[FACTURERECUES] AS [FACTURERECUES], [View_STATFACTCLINIQUE].[PARTASSURANCE] AS [PARTASSURANCE] FROM [dbo].[View_STATFACTCLINIQUE] AS [View_STATFACTCLINIQUE] SELECT [View_STATFACTGENERAL].[ANNEE] AS [ANNEE], [View_STATFACTGENERAL].[MOIS] AS [MOIS], [View_STATFACTGENERAL].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_STATFACTGENERAL].[CATEGORIE_PROFESSIONELLE] AS [CATEGORIE_PROFESSIONELLE], [View_STATFACTGENERAL].[STATUTS] AS [STATUTS], [View_STATFACTGENERAL].[NOMBRE] AS [NOMBRE], [View_STATFACTGENERAL].[FACTURERECUES] AS [FACTURERECUES], [View_STATFACTGENERAL].[PARTASSURANCE] AS [PARTASSURANCE] FROM [dbo].[View_STATFACTGENERAL] AS [View_STATFACTGENERAL] SELECT [View_STATFACTGENERAL_ANNEE].[ID] AS [ID], [View_STATFACTGENERAL_ANNEE].[ANNEE] AS [ANNEE], [View_STATFACTGENERAL_ANNEE].[CATEGORIE_PROFESSIONELLE] AS [CATEGORIE_PROFESSIONELLE], [View_STATFACTGENERAL_ANNEE].[STATUTS] AS [STATUTS], [View_STATFACTGENERAL_ANNEE].[NOMBRE] AS [NOMBRE], [View_STATFACTGENERAL_ANNEE].[FACTURERECUES] AS [FACTURERECUES], [View_STATFACTGENERAL_ANNEE].[PARTASSURANCE] AS [PARTASSURANCE] FROM [dbo].[View_STATFACTGENERAL_ANNEE] AS [View_STATFACTGENERAL_ANNEE] SELECT [View_STATFACTGENERAL_ANNEE_TPASSURE].[ID] AS [ID], [View_STATFACTGENERAL_ANNEE_TPASSURE].[ANNEE] AS [ANNEE], [View_STATFACTGENERAL_ANNEE_TPASSURE].[STATUTS] AS [STATUTS], [View_STATFACTGENERAL_ANNEE_TPASSURE].[NOMBRE] AS [NOMBRE], [View_STATFACTGENERAL_ANNEE_TPASSURE].[FACTURERECUES] AS [FACTURERECUES], [View_STATFACTGENERAL_ANNEE_TPASSURE].[PARTASSURANCE] AS [PARTASSURANCE] FROM [dbo].[View_STATFACTGENERAL_ANNEE_TPASSURE] AS [View_STATFACTGENERAL_ANNEE_TPASSURE] SELECT [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF].[ID] AS [ID], [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF].[ANNEE] AS [ANNEE], [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF].[CATEGORIE_PROFESSIONELLE] AS [CATEGORIE_PROFESSIONELLE], [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF].[STATUTS] AS [STATUTS], [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF].[NOMBRE] AS [NOMBRE], [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF].[FACTURERECUES] AS [FACTURERECUES], [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF].[PARTASSURANCE] AS [PARTASSURANCE] FROM [dbo].[View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF] AS [View_STATFACTGENERAL_ANNEE_TPASSURE_CATPROF] SELECT [View_STATFACTGENERAL_MOIS].[ANNEE] AS [ANNEE], [View_STATFACTGENERAL_MOIS].[MOIS] AS [MOIS], [View_STATFACTGENERAL_MOIS].[CATEGORIE_PROFESSIONELLE] AS [CATEGORIE_PROFESSIONELLE], [View_STATFACTGENERAL_MOIS].[STATUTS] AS [STATUTS], [View_STATFACTGENERAL_MOIS].[NOMBRE] AS [NOMBRE], [View_STATFACTGENERAL_MOIS].[FACTURERECUES] AS [FACTURERECUES], [View_STATFACTGENERAL_MOIS].[PARTASSURANCE] AS [PARTASSURANCE] FROM [dbo].[View_STATFACTGENERAL_MOIS] AS [View_STATFACTGENERAL_MOIS] SELECT [View_STATFACTPHARMACIE].[ANNEE] AS [ANNEE], [View_STATFACTPHARMACIE].[MOIS] AS [MOIS], [View_STATFACTPHARMACIE].[LIBELLEMOIS] AS [LIBELLEMOIS], [View_STATFACTPHARMACIE].[CATEGORIE_PROFESSIONELLE] AS [CATEGORIE_PROFESSIONELLE], [View_STATFACTPHARMACIE].[STATUTS] AS [STATUTS], [View_STATFACTPHARMACIE].[NOMBRE] AS [NOMBRE], [View_STATFACTPHARMACIE].[FACTURERECUES] AS [FACTURERECUES], [View_STATFACTPHARMACIE].[PARTASSURANCE] AS [PARTASSURANCE] FROM [dbo].[View_STATFACTPHARMACIE] AS [View_STATFACTPHARMACIE] SELECT [View_SYNTHESEFACTUREPHARMACIE].[CATEGORIE] AS [CATEGORIE], [View_SYNTHESEFACTUREPHARMACIE].[ACTE] AS [ACTE], [View_SYNTHESEFACTUREPHARMACIE].[FACTURES_VALIDEES] AS [FACTURES_VALIDEES], [View_SYNTHESEFACTUREPHARMACIE].[CONSOMMATION_REELLE] AS [CONSOMMATION_REELLE], [View_SYNTHESEFACTUREPHARMACIE].[ANNEE] AS [ANNEE], [View_SYNTHESEFACTUREPHARMACIE].[MOIS] AS [MOIS], [View_SYNTHESEFACTUREPHARMACIE].[JOUR] AS [JOUR] FROM [dbo].[View_SYNTHESEFACTUREPHARMACIE] AS [View_SYNTHESEFACTUREPHARMACIE] SELECT [VueCategorie_Professionelle].[LIBELLE_CATEGORIE_PROFESSIONELLE] AS [LIBELLE_CATEGORIE_PROFESSIONELLE], [VueCategorie_Professionelle].[nombre_assures] AS [nombre_assures] FROM [dbo].[VueCategorie_Professionelle] AS [VueCategorie_Professionelle] SELECT [VueCategorie_typeAssure].[LIBELLE_CATEGORIE_PROFESSIONELLE] AS [LIBELLE_CATEGORIE_PROFESSIONELLE], [VueCategorie_typeAssure].[LIBELLE_TYPE_ASSURE] AS [LIBELLE_TYPE_ASSURE], [VueCategorie_typeAssure].[ID_TYPE_ASSURE] AS [ID_TYPE_ASSURE], [VueCategorie_typeAssure].[nombre_types_assures] AS [nombre_types_assures] FROM [dbo].[VueCategorie_typeAssure] AS [VueCategorie_typeAssure] SELECT [Vueglobale].[LIBELLE_CATEGORIE_PROFESSIONELLE] AS [LIBELLE_CATEGORIE_PROFESSIONELLE], [Vueglobale].[IDENTREPRISES] AS [IDENTREPRISES], [Vueglobale].[ID_TYPE_ASSURE] AS [ID_TYPE_ASSURE], [Vueglobale].[LIBELLE_TYPE_ASSURE] AS [LIBELLE_TYPE_ASSURE], [Vueglobale].[RAISONSOCIALE] AS [RAISONSOCIALE], [Vueglobale].[nombre_assures] AS [nombre_assures] FROM [dbo].[Vueglobale] AS [Vueglobale]