Borislav,

a another way...

( I m not a super king in sql script !...:)

I think that subquery is possible in xcase ...

CREATE CURSOR Employee ( Iid I  )
  CREATE CURSOR Contrat_l ( Iid I  , iemployeeiD I , ddebut D(8) , dfin D(8) )

  FOR x = 1 TO 60
    INSERT INTO Employee VALUES (x)
  ENDFOR

  m.lDCurrentDate = DATE()

  INSERT INTO Contrat_l VALUES ( 1 , 4 , {^2005/03/18}, {^2005/09/15} )
  INSERT INTO Contrat_l VALUES ( 2 , 14 , {^2001/06/13}, {^2006/01/12} )
  INSERT INTO Contrat_l VALUES ( 3 , 14 , {^2007/01/12}, {} )
  INSERT INTO Contrat_l VALUES ( 4 , 22 , {^2003/01/12},  {^2003/09/12} )
 INSERT INTO Contrat_l VALUES ( 5 , 22 , {^2004/01/12},  {^2006/11/12} )


  SET ENGINEBEHAVIOR 90

  SELECT Employee.Iid,;
    ( SELECT NVL( Contrat_l.iemployeeiD , 0 ) AS 'test'  FROM Contrat_l LET JOIN ;
    Employee.Iid = Contrat_l.iemployeeiD GROUP BY Contrat_l.iemployeeiD ) FROM Employee

I have a strange group by error ...


bernhart