Hi to all , I am newbie in nhibernate. Most of the work I have done with sql queries.I need to perform a task in which two tables are exist, Employees and Admin.
In admin Table there are only two columns,( AdminID and EmployeeID),where EmployeeID is a foreign key and I want to fetch data like this with create criteria

"Select *,isnull((Select AdminID from Admin Where EmployeeID=emp.EmployeeID),0) as AdminID from Employee emp Where emp .Email=@Email"


please help me out