aspose file tools*
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unnecessary INNER JOIN with Criteria