ZDDRM Les regroupements de paie

select a.cdregl, a.cdcode
from zd00 a, zdar b
where a.nudoss = b.nudoss
and a.cdstco = 'DRM'
and b.datxxx = '31/12/2999'
and ( b.libl01 || b.libl02 || b.libl03 || b.libl04 like '%&cdcode%');

select a.CDCODE, b.DAEFF, b.LIBL01, b.LIBL02, b.LIBL03, b.LIBL04
from PRDHR.ZD00 a, PRDHR.ZDAR b
where a.NUDOSS = b.NUDOSS
and a.CDSTCO = 'DRM' and a.CDCODE = '403'
order by b.DAEFF