select tl.*
from dbo.TransactionsLog tl
inner join dbo.PartnershipLegalEntityShareClassMap map on tl.mappingId=map.MappingId
inner join dbo.LegalEntityShareClasses lesc on map.legalEntityShareClassID=lesc.LegalEntityShareClassID
inner join dbo.LegalEntities le on lesc.LegalEntityID=le.LegalEntityId
inner join (
select max(modificationDate) as modificationDate, transactionId as transactionId
from dbo.TransactionsLog
group by transactionId) v on v.modificationDate = tl.modificationDate and v.transactionId = tl.transactionId
where <some critiera>

<hibernate-mapping schema="dbo">

   <!-- this is what I'm doing to try to create "immutable mapping" for my view -->
   <class
      name="com.mycompany.transaction.TransactionsLogBean"
      entity-name="currentTransactionsLogBean">

<!-- tried to just retrieve the list of Ids so I could perform an 'in' -->

      <subselect>
         select tl.* from dbo.TransactionsLog tl
         inner join (select transactionid, max(modificationDate) as
         modificationDate from dbo.TransactionsLog group by
         transactionId) v on v.modificationDate = tl.modificationDate
         and v.transactionId = tl.transactionId
      </subselect>
      <synchronize table="TransactionsLog" />
      <id name="transactionsLogId" />
   </class>
   
   <!-- this is the standard mapping I'm using (works fine) -->   
   <class
      name="com.harrisalternatives.struts.research.transaction.TransactionsLogBean"
      entity-name="TransactionsLog" table="TransactionsLog">

      <id name="id">
         <column name="TransactionsLogId" />
         <generator class="native" />
      </id>

      <property name="typeId" />

      <property name="investmentDate">
         <column name="investDate" />
      </property>
      

      <!-- other props, etc. -->

      <many-to-one name="transaction" column="transactionId"
         not-null="true" entity-name="Transaction" />
         
         
      <!-- more props, etc. -->
   </class>   
</hibernate-mapping>