I am trying to create either Criteria or HQL where I skip an association but having problems find out if it is possible.

Say I have table A which has a one to many with B. B contains a foreign key that is also in C. But no mapping is defined between B and C. It is not mapped as I do not want to touch table X that the shared foreign keys map to.

In normal sql I would simply do a "left join on b.fk_something=c.fk_something"

When I introduce the word "on" it states it is not allowed. Is anything like I am attempting possible?

Thanks,
Martin.

You cannot do outer joins without a mapped association.