I've several entities that (except that one class, I did prevent that circular dependency) each have a dependency on at least one other class.
For example a Category has a Memo.
Is there any way to get JPA to generate SQL like
select c.id, c.description, m.id, m.text from category c, memo m where m.id = c.memo_id
rather than the far less efficient (in database round tripping and query execution time)
select id, description, memo_id deom category
followed by
select id, text from memo where id = ?1
for each returned record from the first query?