ZDDRK Liste des organismes

select a.cdcode "Code",
replace(b.liblon, '**', 'NPU ') "Libellé",
case c.tycais 
  when 'A' then 'ARRCO'
  when 'C' then 'AGIRC'
  when 'D' then 'AGIRC-ARRCO'
  when 'M' then 'Mutuelle'
  when 'P' then 'Prévoyance'
  when 'U' then 'Autres caisses retraite'
  when 'Z' then 'Autre'
  else c.tycais
end "Type",
c.nucais "Numéro institution"
from zd00 a, zd01 b, zdcc c
where a.nudoss = b.nudoss
and a.nudoss = c.nudoss
and a.cdstco = 'DRK' 
order by a.cdcode
;