[Logo]
Forums Register Login
Can I join two tables in a NamedQuery?
Hello,

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.

Thanks for the help.

Reply locked
This thread has been viewed 753 times.

All times above are in ranch (not your local) time.
The current ranch time is
Oct 22, 2018 16:31:05.