Hibernate version:2.1.6

Hello there! Our system has an object that one of its properties is not mapped to a table, instead that property comes from a 1-1 table relation (We are not allowed to change schema)
So I have a

Product table
ProductType table
and Product_ProductType table

as odd as it seems, product does not has a type on it, instead, for each product on the product table we have a relation o the link table (????)

Now, what I first tried is to use native sql to join those tables (I really wouldn like to map that abomination table). But I get a QueryException since the property is not mapped to a column.

How could I do this without mapping? Is it possible?


Regards