When you join a table with JoinType.LEFT and join another to that one, you may need to use JoinType.LEFT again, even when there should be a record in the third table for each record in the second table.
Why?
4 classic reads, newly available on Google Books
8 hours ago
