1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| select distinct b.X1, c.X2, c.X3 as "nom usuel", c.x4 as "nom naissance", c.X5, a.X6 as "mail pro et mail perso",
a.X5 as "mail", b.X6 as "position admi", g.X7 as "Libellé long", g.X8 as "Lib court",
d.X8 as "DIRECTION A", e.dX9 as "DIRECTION B"
from table1 a, table2 b, table3 c, table4 d, table5 e, table6 f, table7 g
where b.X6<>'PPP'
and a.X6 in ('mail pro','mail perso')
and b.X9='WWW'
and b.X10 > sysdate
and b.X6 in ('WWW', 'WWW')
and d.X11='NNN'
and a.X1=b.X1
and a.X1=c.X1
and a.X1=d.X1
and a.X1=e.X1
and f.X12 = 'BBB'
and f.X13=b.X6
and f.X1=g.X1
order by c.X2; |
Partager