Average Hibernate / SQL of a table with multiple relationships

Question

Navigation

#1 by (1 votes)

0

I have the following tables

TABLE1
id
value table2

TABLE2
id
table3

TABLE3
id

And with that, I would like to average TABLE 1, with WHERE in the TABLE 3 parameters with Hibernate / persistence, where my tables are objects.

It would look like this: SELECT AVG (value) FROM table1 WHERE table1.table2.table3.id = N?

java hibernate jpa

asked by anonymous 01.11.2017 / 18:33

1 answer

score 1 · Accepted Answer

Considering that:

So you can do:

select avg(t.valor) from Tabela1 t where t.tabela2.tabela3.id = {valor}