Hi all,


Here is my command.

SET ENGINEBEHAVIOR 90

UPDATE AgendaPhar;
    SET ltransfert = ;
    NVL( ( SELECT E.ltransfert ;
    FROM  Traiter T INNER JOIN Etats E ON  T.Iresidentid = E.Iresidentid AND T.iid = AgendaPhar.itraiterId;
    INNER JOIN DatesFiltred D ON D.ddate BETW E.ddebut  AND EVL( E.dfin , vp_date );
    WHERE E.ltransfert = .T. ) , .F. )

I want that my subquery is single.( one record )

If i try a Group by claus , it is not possible ...
What can i do ?



Thank in advance

bernhart