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 .ema...@email"


please help me out

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to