>* try 3 : can to go in error if (cTrans_fk ,iSequence_Number) is not unique and is it slow too ? >SELECT X.cTrans_pk cTrans_fk; > , (SELECT TI.cInsurances_fk FROM Trans_Insurances TI ; > WHERE TI.cTrans_fk = X.cTrans_pk AND TI.iSequence_Number = X.iSequence_Number); > cInsurances_fk; > FROM (select curTemp.cTrans_pk , max(T.iSequence_Number) iSequence_Number; > from curTemp JOIN Trans_Insurances T ON curTemp.cTrans_pk = T.cTrans_fk ; > GROUP BY 1) X ; >into cursor curTemp1 >>