ZDHKK Les positions administratives / Positions statutaires (Fonction Publique)

select trim(a.cdcode) "Code PA",
trim(b.liblon) "Position administrative",
trim(c.possta) "Code PS", trim(d.liblon) "Position statutaire"
from zd00 a, zd01 b, zdf4 c,
( select za.cdcode, zb.liblon from zd00 za, zd01 zb where za.nudoss = zb.nudoss and za.cdstco = 'HK1' and zb.cdlang = 'F' ) d
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and a.cdstco = 'HKK'
and b.cdlang = 'F'
and c.possta = d.cdcode
order by a.cdcode;

select a.cdcode, b.liblon, c.stcgef, d.liblon, d.stempl
from zd00 a, zd01 b, zd0k c,
(select za.cdcode, zb.liblon, zc.stempl
from zd00 za, zd01 zb, zd0j zc
where za.nudoss = zb.nudoss
and za.nudoss = zc.nudoss
and za.cdstco = 'UAJ' and zb.cdlang = 'F') d
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss(+)
and a.cdstco = 'HKK'
and c.stcgef = d.cdcode ;