Hi,

Is there any way to create a many-to-many mapping without a join table. Just to make something up by way of explanation, something like



Sure, I could make a view to provide the join table. But is there any way I can do it using just hibernate mapping markup.


Thanks very much,
Mike.

PS This is a more succinct restatement of http://forum.hibernate.org/viewtopic.php?t=960708

<join>
<key column="employeeId"/>
<subselect>
select employeeId, orgId
from Employments
group by orgId
having startDate = max(startDate)
</subselect>
<many-to-one name="mostRecentEmployer"
class="Organization"
column="orgId"/>
</join>