• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unnecessary INNER JOIN with Criteria

 
Darlan Moraes
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I'm working on a method in which a given table needs to join with another and with a field of the second table still another comparison do with it. Something like:



The method is as follows:



And the only mapping that exists is unidirectional, from Subs to Auth:



This works, but OpenJPA does the following:



Does anyone know how to avoid this second join?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic