ZDDL9 Compteurs du PRDB et leurs alimentations

select a.cdcode "Compteur PRDB",
b.liblon "Libellé compteur",
c.cdrubr "Rubrique de paie",
d.liblon "Libellé rubrique",
c.tyalim "Type d'alimentation",
c.cdsign "Signe"
from zd00 a, zd01 b,
zda4 c,
(select za.cdcode, zb.liblon from zd00 za, zd01 zb where za.nudoss = zb.nudoss and za.cdstco = 'DRC') d
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and c.cdrubr = d.cdcode
and a.cdstco = 'DL9'
and a.cdcode like 'W%' ;