jpaRepository + JPQL + JOIN

Question

jpaRepository + JPQL + JOIN

Navigation

#1 by (0 votes)

1

I have query down running in my code but using the actual names of the table and fields, the same structure below works, but how do I do the same but using the JPQL language, I am using names generic table and fields just to make it easier to understand.

@Query(value = "select rc.* from tabela1 i  join tabela2 rc on rc.campoA= i.campoA")                             
public Page<Tabela2> trazerResultado(Pageable pageable);

jpql

asked by anonymous 19.04.2018 / 21:15

1 answer

GLM with the multivariate normal How to delete User using Parse (Error: insufficient auth to delete user)

score 0 · Accepted Answer

Understanding that the entities Table1 and Table2 do not have a relationship with each other, and you just want to make a JOIN between them, we can do this via WHERE :

@Query(value = "SELECT tab2 FROM Tabela1 tab1, Tabela2 tab2 
    WHERE tab1.campoA = tab2.campoA")

In Hibernate's newer versions (as of 5.1) you can use ON also, making it possible to query between entities without relationship:

@Query(value = "select rc from Tabela1 tab1 
   JOIN Tabela2 rc ON rc.campoA = tab1.campoA")