> INNER JOIN Trans_Insurances on ; > Trans.cTrans_pk = Trans_Insurances.cTrans_fk ; > AND Trans_Insurances.iSequence_Number= ; (select max(iSequence_Number) ; FROM Trans_Insurances X ; WHERE X.cTrans_fk = Trans_Insurances.cTrans_fk ); > INNER JOIN Insurances on ; > Trans_Insurances.cInsurances_fk = Insurances.cInsurances_pk ; > INNER JOIN Carrier_Branches on ; > Insurances.cCarrier_Branches_fk = ; > Carrier_Branches.cCarrier_Branches_pk ; > INNER JOIN Carriers on ; > Carrier_Branches.cCarriers_fk = Carriers.cCarriers_pk > >>
> INNER JOIN Trans_Insurances on ; > Trans.cTrans_pk = Trans_Insurances.cTrans_fk ; > INNER JOIN (SELECT cTrans_fk,max(iSequence_Number) iSequence_Number FROM Trans_Insurances GROUP BY 1) Last; > ON Trans_Insurances.cTrans_fk = Last.cTrans_fk AND Trans_Insurances.iSequence_Number = Last.iSequence_Number ; > INNER JOIN Insurances on ; > Trans_Insurances.cInsurances_fk = Insurances.cInsurances_pk ; > INNER JOIN Carrier_Branches on ; > Insurances.cCarrier_Branches_fk = ; > Carrier_Branches.cCarrier_Branches_pk ; > INNER JOIN Carriers on ; > Carrier_Branches.cCarriers_fk = Carriers.cCarriers_pk > >>
and Trans_Insurances.iSequence_Number = ; (select max(iSequence_Number) from TI ; group by ... where TI.cTrans_fk = Trans.cTrans_pk)What do you think?