wood burning stoves 2.0*
The moose likes JDBC and the fly likes Unnecessary INNER JOIN with Criteria Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unnecessary INNER JOIN with Criteria" Watch "Unnecessary INNER JOIN with Criteria" New topic
Author

Unnecessary INNER JOIN with Criteria

Darlan Moraes
Greenhorn

Joined: Jan 08, 2013
Posts: 7
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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Unnecessary INNER JOIN with Criteria