select curTemp.cTrans_pk, TI.cInsurances_fk ; from curTemp inner join Trans_Insurances TI ; on curTemp.cTrans_pk = TI.cTrans_fk ; where TI.iSequence_Number = (select max(iSequence_Number) ; from Trans_Insurances X ; where X.cTrans_fk = TI.cTrans_fk) ; into cursor curTemp1