I have two 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.
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.