How to combine JOIN ON and WHERE in one query. Versions in SQL and HQL.

In SQL it is not a problem to combine both statements. But there are some syntax differences between the SQL versions. In HQL the JOIN ON can be challenging. Here are some ideas and examples. read all...