Convert sql query into nhibernate

See more:

NHibernate

Please convert sql query into nhibernate query. My query is given below.

SQL Query:

SELECT tbl_other_related_family.record_id
,tbl_other_related_family.related_record_id
FROM tbl_record
INNER JOIN tbl_other_related_family
ON tbl_other_related_family.record_id = tbl_record.record_id
INNER JOIN tbl_record AS relatedrecord
ON relatedrecord.record_id = tbl_other_related_family.related_record_id
WHERE tbl_record.isactive = 1
AND relatedrecord.isactive = 1

Nhibernate Query:

ICriteria MyCriteriaOtherRelated = NHibernateHttpModule.CurrentSession.CreateCriteria(typeof(TblRecordVO), "Record")
.CreateAlias("TblOtherRelatedRecordFamily", "Family", NHibernate.SqlCommand.JoinType.LeftOuterJoin);


I don't know that how to join the table "tbl_record" again.

Please help me to convert query into nhibernate.