JPA table JOIN

[Sheetal Tiwari]

Hello,

I have two entities/tables that have one to one relationship and I have created java classes for both of them and annotated with @Entity.
Now for a particular case, I want to join both these tables and fetch the data.

For Example
SELECT * from A,B
where A.id = B.id
order by B.sortOrder

Can tables be joined in @NamedQuery ?
Is yes , could you provide a sample.

If it cannot be done using @namedQuery then is it advisable to use @NamedNativeQuery in this scenario.

Thanks for the help.

[Pierre Sugar]

You might find this site helpfull. There is an example that would answer your question:

 SELECT DISTINCT mag1 FROM Magazine mag1, Magazine mag2
WHERE mag1.price > mag2.price AND mag2.publisher.name = 'Adventure'
   

But I am wondering as you have an association to class B I think you could also use this NamedQuery (I didn't try it though).

  @NamedQuery(name="A.findB", query="select a from A a where a.id = a.b.id")  

b in the NamedQuery is the field name of class B in your A class.