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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| select distinct p.NIP, p.NOM, p.PRENOM,sj.DATE_ENT,q3.LIBABR,r3.REPONSE,NULL,NULL,NULL,NULL
from PENSOINS.BM_LIB_S lib2,
PENSOINS.C_QUESTION q3,PENSOINS.BM_REP_S r3,
PENSOINS.BM_TH_S th,PENSOINS.SEJOUR sj,
PENSOINS.PATIENT p
where lib2.PARENTE like '674,%'
and lib2.NIQ = q3.NIQ
and lib2.NILIB = r3.NILIB
and lib2.NIQSUP is NULL
and lib2.NILIBSUP is NULL
and th.NITH = lib2.NITH
and sj.NISEJOUR = th.NISEJOUR
and p.NIPATIENT = sj.NIPATIENT
UNION
select distinct p.NIP, p.NOM, p.PRENOM,sj.DATE_ENT,q3.LIBABR,r3.REPONSE,q2.LIBABR,r2.REPONSE,NULL,NULL
from PENSOINS.BM_LIB_S lib2,PENSOINS.BM_LIB_S lib3,
PENSOINS.C_QUESTION q2,PENSOINS.BM_REP_S r2,
PENSOINS.C_QUESTION q3,PENSOINS.BM_REP_S r3,
PENSOINS.BM_TH_S th,PENSOINS.SEJOUR sj,
PENSOINS.PATIENT p
where lib2.PARENTE like '674,%'
and q2.NIQ = lib2.NIQ
and r2.NILIB = lib2.NILIB
and lib2.NIQSUP = q3.NIQ
and lib2.NILIBSUP = r3.NILIB
and lib2.NIQ = q3.NIQ
and lib2.NILIB = r3.NILIB
and lib3.NIQSUP is NULL
and lib3.NILIBSUP is NULL
and th.NITH = lib3.NITH
and sj.NISEJOUR = th.NISEJOUR
and p.NIPATIENT = sj.NIPATIENT
UNION
select distinct p.NIP, p.NOM, p.PRENOM,sj.DATE_ENT,q3.LIBABR,r3.REPONSE,q2.LIBABR,r2.REPONSE, q1.LIBABR,r1.REPONSE
from PENSOINS.BM_LIB_S lib1,PENSOINS.BM_LIB_S lib2,
PENSOINS.C_QUESTION q1, PENSOINS.BM_REP_S r1,
PENSOINS.C_QUESTION q2,PENSOINS.BM_REP_S r2,
PENSOINS.C_QUESTION q3,PENSOINS.BM_REP_S r3,
PENSOINS.BM_TH_S th,PENSOINS.SEJOUR sj,
PENSOINS.PATIENT p
where lib1.NIQ = q1.NIQ
and lib1.NILIB = r1.NILIB
and lib1.PARENTE like '674,%'
and lib1.NIQSUP = q2.NIQ
and lib1.NILIBSUP = r2.NILIB
and q2.NIQ = lib2.NIQ
and r2.NILIB = lib2.NILIB
and lib2.NIQSUP = q3.NIQ
and lib2.NILIBSUP = r3.NILIB
and th.NITH = lib2.NITH
and sj.NISEJOUR = th.NISEJOUR
and p.NIPATIENT = sj.NIPATIENT |