1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| select m.num, s.numser, s.safnum
from mpser s, mpdem m
where safppl = 0
and s.safnum = m.safnum
UNION all
Select m.num, s2.numser , s2.safnum
from mpdem as m, mpser as s1, mpser as s2
where m.safnum = s1.safnum
and s1.safnum = s2.safppl
UNION all
Select m.num, s3.numser , s3.safnum
from mpdem as m, mpser as s1, mpser as s2, mpser as s3
where m.safnum = s1.safnum
and s1.safnum = s2.safppl
and s2.safnum = s3.safppl
UNION all
Select m.num, s4.numser , s4.safnum
from mpdem as m, mpser as s1, mpser as s2, mpser as s3, mpser as s4
where m.safnum = s1.safnum
and s1.safnum = s2.safppl
and s2.safnum = s3.safppl
and s3.safnum = s4.safppl ; |
Partager