There exists a phenomenon in JPQL/SQL that isn’t quite intuitive in the first place, but gets clearer after you have understand how it works. A normal JOIN in a JPQL query is evaluated as an INNER JOIN. That means, that a row will not be selected, if the right hand side of the JOIN is NULL. This may sometimes lead to unexpected results…
(more…)
