[
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)
