Hibernate version: 2.0

Name and version of the database you are using: SQL 2005

Hi guys. Once again sorry 4 my bad english.

I dont know if its possible, but I have to perform a INNER JOIN operation between two entities.
table and view.
I already mapped both sucefully and now im trying to create a ICriteria to perform this join operation.

One of the issues i have is that the view is mapped using a composite-id.

Basically, the entities have the following fields:

Table

FileId (Key)
FileName
Properties

View

EntityFatherId (Key)
EntityChildId (Key)

In my criteria i need to set the condition where EntityFatherId field is equal to a parameter that i receive, and the join with Table is performed using the EntityChildId = FileId.

So i need some help to build the instructions to do that with ICriteria.

Any ideas?