1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
INSERT INTO tableimpdossier
SELECT D.numdossier AS NumDossier
, D.datedossier AS DateDossier
, D.resultat AS Resultat
, D.commentaire AS Commentaire
, D.medecintraitant AS MedecinTraitant
, E.nomexamen AS NomExamen
, N.desnature AS DesNature
, PR.nompropriete AS NomPropriete
, D.numpatient AS NumPatient
, PA.nompatient AS NomPatient
, PA.prenompatient AS PrenomPatient
, PA.sexepatient AS Sexe
, PA.contactpatient AS ContactPatient
, V.valpatient AS ValPatient
, V.valnormale AS ValNormale
, V.interpretation AS Interpretation
FROM tabledossier D
, tableexamen E
, tablenature N
, tablepropriete PR
, tablepatient PA
, tablevaleur V
WHERE D.numexamen = E.numexamen
AND E.numnature = N.numnature
AND D.numpatient = PA.numpatient
AND D.numdossier = V.numdossier
AND V.numpropriete = PR.numpropriete
AND V.numdossier = " & txtnumdossier & " " |
Partager