In EJB QL, is it possible to do a LEFT JOIN on two entities that have no
declared relationship, thus simulating the ON clause in the sql equivalent??
>From the EJB 3.0 book, they give the example of finding all customers and
>their phone numbers - whether or not they have them:
SELECT c.firstName, c.lastName, p.number FROM Customer c LEFT JOIN
c.phoneNumbers p
That works because there is a declared relationship between Customer and Phone.
What if I didn't have that relationship and wanted to do something more like
this:
SELECT c.firstName, c.lastName, p.number FROM Customer c LEFT JOIN Phone p
WHERE c.someId=p.someId
Is that even possible?
Thanks in advance!
Justin
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4023181#4023181
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4023181
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
