I have the following problem:
TABLE A
-Primary Key name PkId
-A field named hCod not unique
-A field name X
TABLE B
-Primary Key named PkId
-A "foreign key" name idA
-A field named Y

The situation is not the "standard", because there is not foreign key constraint from idA (B) to pkId (A), because in idA of B there is the value of hCod of A. The "join" is made in this way:
SELECT ...
FROM B left outer join A on B.idA = A.hCod
AND B.Y = A.X

Is this possibile with Hibernate? How can I map it?
My real situation is a little more complex (B.Y = A.X is the simplification from the real situation). The important thing is that A must have the primary key on PkId (because there are other relations with that field), so I cannot use hCod+Y as a primary key.

Any help is very appreciated
Thanks
Alessandro Rizzi

Check the property-ref attribute feature

Alredy tried, but it raise an error because hCod is not unique and when Hibernate tries to load a record by hCod, he finds more than once, so it raise an error.
Alessandro

Consider not mapping that. Use an HQL query to retrieve appropriate data.

How can I make that HQL witout mapping?
Is possible to write the outer join statement without mapping? If yes how?
Alessandro

I have a similar problem (linking to a column that is not the primary key), using property-ref fixed all the join-conditions. However, the last condition in the select uses the value of the wrong field:

select ... from po_item_ordered poitemorde0_ left outer join po_item poitem1_ on poitemorde0_.item_id=poitem1_.item_id where poitemorde0_.po_id=1147

The last condition (po_id=1147) is checknig the right field, but against the wrong value:

I have a 1-many relation between po and po_item_ordered.
po has a field po_id (which is 'po3232' in my case) and a field db_id which is the primary key. I want to compare po_item_ordered.po_id against po.po_id, so the query should rather end like this:

po_id='po3232'

How do I do that?