SELECT a.field1,
         SUM(a.field2) field2,
         MAX(b.field3) field3,
         MAX(b.field4) field4
    FROM table_a a,
         table_b b
   WHERE a.field1 = b.field1
         AND a.field1 = ?
         AND b.field4 = ?
GROUP BY a.field1
ORDER BY field2