[ https://issues.apache.org/jira/browse/JDO-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14058470#comment-14058470 ]
RaviRaja commented on JDO-730: ------------------------------ Thanq for you reply, The above query is making cross join. But we need an innerjoin between objects with ON clause. However this can be solved by .contains() clause but it implicitly innerjoins only primary and foreign keys. But we need innerjoin rather than primary and foreign key Query as follows: select this.x, b.y from com.xyz.Class1 where this.contains(b) variables com.xyz.Class2 b This query only innerjoins with ON clause condition this.pkey==b.foreignkey But we need the explicit innerjoins rather than implicit innerjoins > Creating the innerjoin without relationship between objects > ----------------------------------------------------------- > > Key: JDO-730 > URL: https://issues.apache.org/jira/browse/JDO-730 > Project: JDO > Issue Type: Wish > Components: api > Affects Versions: JDO 3.1-rc1 > Reporter: RaviRaja > Assignee: Michael Bouschen > Fix For: JDO 3.1 > > > Cannot make innerjoin like this without relationship: > select a.x, b.y from Table1 as a INNER JOIN Table 2 as b ON a.z=b.w > Note: a.z and b.w are not primary and foreign keys -- This message was sent by Atlassian JIRA (v6.2#6252)