Выборка из двух таблиц

sSQL_M = "SELECT a.CRAYP3, a.MFIFP3 AS MARGA " & _
              "FROM B31SDFH.FHPSTP03 a " & _
              "ORDER BY a.CRAYP3"
 
sSQL_T = "SELECT b.CRAYOJ, MAX(b.CAPERJ) AS TO " & _
              "FROM B31SDFH.FHHVJP00 b " & _
              "GROUP BY b.CRAYOJ " & _
              "ORDER BY b.CRAYOJ"

SELECT MFIFP3 * (SELECT MAX(b.CAPERJ) FROM B31SDFH.FHHVJP00) AS TOTAL FROM B31SDFH.FHHVJP00;

    sSQL_A = "SELECT CRAYOJ " & _
             "FROM B31SDFH.FHHVJP00 " & _
             "WHERE JOURJO = 20 AND MOISJO = 2 AND ANNEJO = 16 AND TYPEDO = '*'"
    sSQL_T = "SELECT b.CRAYOJ AS RAYON, b.CAPERJ AS TO " & _
             "FROM B31SDFH.FHHVJP00 b " & _
             "WHERE b.JOURJO = 20 AND b.MOISJO = 2 AND b.ANNEJO = 16 AND b.CFAMIJ = ( " & sSQL_A & " ) AND NOT b.CRAYOJ = ( " & sSQL_A & " ) " & _
             "ORDER BY b.CRAYOJ"
    sSQL_M = "SELECT (a.MFIFP3 * c.TO / 100) AS TOTAL " & _
             "FROM B31SDFH.FHPSTP03 a, (" & sSQL_T & ") c " & _
             "WHERE a.CRAYP3 = c.RAYON " & _
             "ORDER BY a.CRAYP3"