The following example is listed in the hibernate docs in chapter 7 under "7.6. More complex association mappings" However, this syntax does not work.

<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>

When I try I get the following exception:

Caused by: org.xml.sax.SAXParseException: Attribute "table" is required and must be specified for element type "join".


Is there a newer DTD I should be using which allows this? I am using:

http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd