ICriteria criteria = session.CreateCriteria(typeof(ProjectExts))
.SetProjection(Projections.Property("ProjectID"))
.SetProjection(Projections.Property("ManagerEmpId"))
.SetProjection(Projections.Property("ConsStatCode"))
.CreateCriteria("NewProjectTable", JoinType.InnerJoin)
.SetProjection(Projections.Property("Description"))
.CreateCriteria("UserTable", JoinType.InnerJoin)
.SetProjection(Projections.Property("UserName"))
.SetProjection(Projections.Property("FirstName"))
.SetProjection(Projections.Property("LastName"))
.Add(Restrictions.Eq("ProjectID", ProjectID));


return criteria.List<ProjectExts>();


i am getting an error unable to run sql , what is wrong above...
this is what i need to run

select a.proj_id,a.manager_empid,b.activity_id,b.last_dml_dttm,c.descr,d.user_name
,d.first_name || ' ' || d.last_name as Name
from table a,
table b,
table c,
table d
where a.proj_id=:project_id
and a.proj_id=b.proj_id
and a.proj_id=c.proj_id
and a.manager_empid=d.user_id

anything looks bad up there..
thanks