I'd like to do a join within a <class> mapping to another table with a composite primary key, where one of the columns of the composite key in my mapping should be fixed, i.e. something like the following:

[code]<join table="some_other_table">
<key column="foreign_key_column1" />
<key formula="FIXED_VALUE" />

<property name="..." />
</join>[/code]

I'm working with legacy data, where I cannot change the schema. Unfortunately Key Mappings don't allow a formula attribute. Is there any way around this?

Thanks,
Stefan