1 2 3 4
| PARAMETERS [date effet] DateTime;
SELECT Adherent.Filiale AS [Nom du délégataire], [ContratActif_A-C].rum AS [Numéro Contrat Allianz], Null AS [Numéro contrat délégataire], Null AS [Numero SS], [ContratActif_A-C].garantie AS [type de garantie], Adherent.nom, Null AS [Nom usage], Adherent.prenom, Null AS [Prenom 2], Null AS [prenom 3], Adherent.dtnaissance AS [Date de naissance], Adherent.qualite AS Sexe, Adherent.ville AS [Commune de naissance], Adherent.dtentree AS [Date entrée], Adherent.dtsortie AS [date sortie], [ContratActif_A-C].MotifResiliation AS [motif sortie], Adherent.commentaire, [ContratActif_A-C].Matricule, [ContratActif_A-C].DtEffet, [ContratActif_A-C].DtFin
FROM Adherent INNER JOIN [ContratActif_A-C] ON Adherent.Matricule = [ContratActif_A-C].Matricule
WHERE ((([ContratActif_A-C].DtEffet)<=[date effet]) AND (([ContratActif_A-C].DtFin)>=[date effet] Or ([ContratActif_A-C].DtFin) Is Null)); |
Partager