Constructing a Full-Outer-Join Style View Across Two Entities with Spring Data JPA
When two tables are related but you either don’t model the association or cannot rely on right joins through the Criteria API, you can still project a full "view" by composing three queries: interscetion (inner join), left-only, and right-only. The union of these results behaves like a ful...