1 2 3 4 5
| select ACTE.NUMACT, ACTE.DATACT, ACTE.AGEGEST, ACTE.NBCPN, ACTE.VACANTITET, ACTE.NBECHO, ACTE.PHALASSO, ACTE.PAYACT, ACTE.RESTPAYACT, ETABLISSEMENT.NUMETS, ETABLISSEMENT.NOMETS, TYPE_ACTE.LIBTYPACT, TYPE_ACTE.NUMTYPACT, PATIENTE.NPPAT, PATIENTE.NUMPAT, DIAGNOSTIC.LIBDIAGN, DIAGNOSTIC.NUMDIAGN, MOTIF.LIBMOTIF, MOTIF.NUMMOT, EXAMEN_DEMANDE.LIBEXAM, EXAMEN_DEMANDE.NUMEXAM, ORIENTATION.LIBORIENT, ORIENTATION.NUMORIENT, MOTIF_ACTE.NUMACT, MOTIF_ACTE.NUMMOT, EXAMEN_ACTE.NUMACT, EXAMEN_ACTE.NUMEXAM, ORIENTATION_ACTE.NUMACT, ORIENTATION_ACTE.NUMORIENT, ASSUREUR.NOMASSUR, ASSUREUR.NUMASSUR
from ETABLISSEMENT, DIAGNOSTIC, PATIENTE, TYPE_ACTE, MOTIF, MOTIF_ACTE, EXAMEN_ACTE, EXAMEN_DEMANDE, ORIENTATION, ORIENTATION_ACTE, ACTE, ASSUREUR
where ASSUREUR.NUMASSUR=PATIENTE.NUMASSUR, PATIENTE.NUMPAT=ACTE.NUMACT, ETABLISSEMENT.NUMETS=ACTE.NUMETS, DIAGNOSTIC.NUMDIAGN=ACTE.NUMDIAGN, TYPE_ACTE.NUMTYPACT=TYPE_ACTE.LIBTYPACT, ACTE.NUMACT=MOTIF_ACTE.NUMACT, MOTIF.NUMMOT=MOTIF_ACTE.NUMMOT, ACTE.NUMACT=EXAMEN_ACTE.NUMACT, EXAMEN_DEMANDE.NUMEXAM=EXAMEN_ACTE.NUMEXAM, ACTE.NUMACT=ORIENTATION_ACTE.NUMACT, ORIENTATION.NUMORIENT=ORIENTATION_ACTE.NUMORIENT |
Partager