Выборка из 3-х таблиц, с нахождением максимальных значений по двум полям и группировкой

SELECT        F.PAYERID, S.CSHORTNAME, S.UNP, F.RYEAR, F.REPORTDATE, F.QUATER, F.ENSPEOPLEY, T.PAYERSTATECODE
FROM            ARM.TBL1FUNDSIDE1 F, ARM.TBLPAYER S,
                             (SELECT        PAYERID, MAX(REPORTDATE) AS REPORTDATE
                               FROM            ARM.TBL1FUNDSIDE1
                               GROUP BY PAYERID) X, ARM.TBLPAYERSTATUSHISTORY T
WHERE        F.PAYERID = S.PAYERID AND F.PAYERID = X.PAYERID AND F.REPORTDATE = X.REPORTDATE AND S.PAYERID = T.PAYERID AND (F.PAYERID BETWEEN 
                         400000000 AND 499999999) AND (T.PAYERSTATECODE <> 2 OR
                         T.PAYERSTATECODE <> 7) AND (F.ENSPEOPLEY > 10)

SELECT        F.PAYERID, S.CSHORTNAME, S.UNP, F.RYEAR, F.REPORTDATE, F.QUATER, F.ENSPEOPLEY, T.PAYERSTATECODE, T.BEGINDATE
FROM            ARM.TBL1FUNDSIDE1 F, ARM.TBLPAYER S,
                             (SELECT        ARM.TBL1FUNDSIDE1.PAYERID, MAX(ARM.TBL1FUNDSIDE1.REPORTDATE) AS REPORTDATE, MAX(ARM.TBLPAYERSTATUSHISTORY.BEGINDATE) 
                                                         AS BEGINDATE
                               FROM            ARM.TBL1FUNDSIDE1, ARM.TBLPAYERSTATUSHISTORY
                               GROUP BY ARM.TBL1FUNDSIDE1.PAYERID) X, ARM.TBLPAYERSTATUSHISTORY T
WHERE        F.PAYERID = S.PAYERID AND F.PAYERID = X.PAYERID AND F.REPORTDATE = X.REPORTDATE AND S.PAYERID = T.PAYERID AND (F.PAYERID BETWEEN 
                         400000000 AND 499999999) AND (T.PAYERSTATECODE <> 2 OR
                         T.PAYERSTATECODE <> 7) AND (F.ENSPEOPLEY > 10)

WHERE ARM.TBL1FUNDSIDE1.PAYERID = ARM.TBLPAYERSTATUSHISTORY.PAYERID

SELECT PAYERID, MAX(BEGINDATE) AS BEGINDATE
  FROM ARM.TBLPAYERSTATUSHISTORY
 GROUP BY PAYERID