ZDUAA Les sociétés

select a.CDCODE, b.POPCOT, b.TYPCAI, b.REGIME, c.LIBLON, b.DEBCAI, b.FLALIM, b.FINCAI, b.REFCAI, b.COMCAI
from QUAHR.ZD00 a, QUAHR.ZDFT b,
(select za.CDCODE, zb.LIBLON from QUAHR.ZD00 za, QUAHR.ZD01 zb where za.NUDOSS = zb.NUDOSS
and za.CDSTCO = 'DRX' and zb.CDLANG = 'F') c
where a.NUDOSS = b.NUDOSS
and a.CDSTCO = 'UAA'
and b.REGIME = c.CDCODE

select a.cdcode "Code", b.liblon "Libellé", c.idcp00 as "Règlementation" from zd00 a, zd01 b, zd0a c
where a.nudoss = b.nudoss and a.nudoss = c.nudoss
and a.cdstco = 'UAA'
order by a.cdcode ;

select trim(a.cdcode) "Code", trim(b.liblon) "Libellé", trim(b.libabr) "Libellé"
from zd00 a, zd01 b
where a.nudoss = b.nudoss
and a.cdstco = 'UAA'
order by a.cdcode ;