Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Unnecessary INNER JOIN with Criteria  RSS feed

 
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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!