>>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 >>>>