Hello,
I would like to use HQL to query and join two tables that don't have a 'proper' foreign key association. Is this possible?
So we basically have these 3 tables (distilled down to their essence).

The Debtor and Item rows will be persisted separately and we purposely don't want a debtorId (way data is loaded we can't make the association at persist time) on the Item table (but I fear that is what the answer will be!).
In SQL I can perform the join easily on Item and Debtor to get Debtor names for Items (where they exist):

But obviously I can't do this in HQL without providing a mapping of some kind. But I'm not sure how to map it - or if it is possible/advisable.
I have had a look around and am none the wiser about how to proceed so if anyone could point me in the correct direction it would be most appreciated.
Cheers
Mat