ZU00 Les stages

select a.idcr00, a.idcl00, a.dtcl00, a.dtstcl, b.lbcllg from zu00 a, zu01 b
where a.nudoss = b.nudoss ;

select a.idcr00, a.idcl00, a.dtcl00, a.dtstcl, b.lbcllg, c.dtefcl, c.dtencl 
from zu00 a, zu01 b, zu2a c
where a.nudoss = b.nudoss 
and a.nudoss = c.nudoss
and c.dtefcl > sysdate
;