There is a query type request.
query.select(t1.name,
t1.type,
t2.name,
t2.type,
quantity,
sum
)
.from(t1)
.inner Join(t2).on(t1.t2.id.eq(t2.id))
.where(predicate)
.group By(t1.name,
t1.type,
t2.name,
t2.type)