>>>SELECT R1.Cnomcustomer ,; >>> R1.Iid ,; >>> Cor9.IetatId , ; >>> Cor9.nType ,; >>> Cor9.ccat_Physiq , ; >>> cor9.ddebut,; >>> cor9.Ltransfert; >>>FROM Amline!Resident R1; >>>INNER JOIN (SELECT Etats.iresidentId , ; >>> NVL( Etats.nType, 0 ) AS nType ,; >>> Etats.iid AS IetatId ,; >>> Etats.ccat_Physiq AS ccat_Physiq,; >>> NVL( Etats.lTransfert , .F. ) AS lTransfert ,; >>> Etats.ddebut AS ddebut; >>> FROM Etats; >>> INNER JOIN (SELECT IresidentId,; >>> MAX(IID) AS IId; >>> FROM Etats; >>> GROUP BY IresidentId) Etst ON Etats.IresidentId = Etst.IresidentId AND; >>> Etats.IId = Etst.IID) Cor9 ; >>> ON R1.iid = cor9.iresidentId ; >>>WHERE EMPTY( TTOD( R1.dsortie ) ); >>>ORDER BY R1.Cnomcustomer; >>>INTO CURSOR temp >>>>>>