1 2 3 4
| SELECT DISTINCT N.NumNote AS N°Note, N.DateNote, C.NumContrat AS N°Cont, Cl.NumCli AS N°Cli, Cl.NomCli AS NomClient, C.DateEffetContrat AS DateEffet, C.NatureContrat AS Nature, V.NomVendeur, S.NumEmploye, S.PrenomEmploye AS Redacteur, A.NumAgence, A.NomAgence, V.NumVendeur, N.ValidNote
FROM NOTES AS N, CONTRAT AS C, CLIENT AS Cl, AGENCE AS A, VENDEUR AS V, SERV_ASSU AS S, Avoir AS Av
WHERE C.NumContrat=N.NumContrat And C.NumCli=Cl.NumCli And C.NumAgence=A.NumAgence And C.NumVendeur=V.NumVendeur And N.NumEmploye=S.NumEmploye And N.NumNote=Av.NumNote And N.CatNote=1
ORDER BY N.ValidNote DESC , N.DateNote; |
Partager