Hello All
I would like to get your guidance for the mapping problem I have:

I have a class "Image". It is mapped to a table "Images" that holds the ID and name of the Image.
There is another table called "OLEObjects" which holds its own ID, an Image ID, and then the file name, image size and other technical info.

I have no use for an "OLEObject" class.

Now - in my class "Image" I need to map the "file size" "file name" etc properties from the OLEObject table.

The <join> element doesn't work for me, because in the "Image" table I do not have an "OLEObject ID" but rather the other way around (the link is from OLEObject to Image)

So I need something that will allow me to link the OLEObject using its ImageID field, and than get the "file name" "file size" values from it.

What is the best way to tackle this in Hibernate 3 ?

Thank you !

Elad